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.
Yes, I tried, but it append blank row in table.
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
1 Like