Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleteing Pictures | New Users to Excel | |||
deleteing objects | Excel Discussion (Misc queries) | |||
Deleteing | Excel Discussion (Misc queries) | |||
Deleteing empty rows | Excel Discussion (Misc queries) | |||
Deleteing some Rows | Excel Discussion (Misc queries) |