Delete blank cells in a table

[nando88]

I have a problem with some workbooks I am working with. These workbooks have multiple tables in a single sheet and some of the tables have blnk cells and I would like to be able to delete these blank cells with vba, the only problem is that I can't delete the entire row, because I may delete the contents of the other tables.
Is there a simple way I can accomplish the right click option of deleting a cell in a table with vba?
Any help will be greatly appreciated.
Thanks.

 

[Automatrix]

While it's not macro-based, you can handily solve this by importing your table into Power Query and then removing rows with blank cells, and you won't have to write a single line of code.