Deleting Blank Rows from Excel
Posted on 2011-10-17
I have a number of dynamic tabs in an Excel file and I need help with VBA on each tab which will delete any blank rows. For example, if there are headers in columns A-G, and a user puts values in any of the cells in each row but skips and entire row of cells, upon closing I want the VBA to delete that blank row.
I've been trying to figure it out but I'm going in circles. Any help would be greatly appreciated.