Forum Discussion
Dont display table if empty
Hi, I have two tables (A and B) that merge as a single table(C), If table B is empty i dont want the table(C) to be displayed on the sheet. I have tried ISempty function for some reason i fee...
is there a way to clear the table if there is no more than 2 rows in the table using VBA?
I know how to clear the worksheet but not sure how to clear the specific table based on the condition.
There's probably a way to check if the table X amount of rows and then you can delete the table in VBA.
I'd recommend posting questions around VBA for Excel on the forum below:
office-vba-dev - Microsoft Q&A
These sorts of automations are primarily driven outside of Power Query and only enabled or limtied by the product integration which in this case is Excel, so it is recommended that you post this question in a forum more focused towards Excel like the one I provided above.
Best!