Request a method to append range where if that row is not empty If it's free, don't append

Request a method to append range where if that row is not empty If it’s empty, don’t append. The problem now is that Filter doesn’t see it. Append emthy row and put it in the Table.

@Sarttra

Did you try with append range directly?

Cheers

Yes, I tried, but it append blank row in table.

@Sarttra

then your datatable might have blank rows…filter before appending

or check if there is some data sometimes excel would not show data but the rows or cells might be used as there might be a small space or formatting done for the cells

cheers