Deleteing Blank Rows
assume if the cell is blank in column A, then the row should be deleted
Columns(1).specialCells(xlblanks).EntireRow.Delete -- Regards, Tom Ogilvy "dayton" wrote in message ... In my macro I need to delete rows that are blank down to the end of the file. The file's will not always be the same. What would the code be for this? T.I.A. |
All times are GMT +1. The time now is 05:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com