There is probably an easy solution to this that I have overlooked, but...
i have written a Routine in VBA that consolidates data from 70 user spreadsheets into a master file every evening. The extraction runs OK, but the master file contains sporadic blank rows that are being imported from the user sheets. Thats all fine, but these blank rows cause other routines that call the master file to fail. Is there a method in VBA that can check through a range (c. 5000 rows), select entire blank rows, and delete them? Thanks in advance for any ideas.
Using For...Next Loops to test for "" in a cell on a row isn't really a reliable option because there can be data in any column from A to AQ on a row. I'm only interested in entirely blank rows.
I also tried "Selection.SpecialCells(xlCellTypeBlanks).Sele ct" - no good as this will also select the valid rows. This really is driving me crazy - i'd appreciate a fresh perpective!
Excel 97 - I'll post the code if requested.