Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete blank rows
Hello,
I'm returning some address lines into separate cells, some of which will be blank. Is it possible to delete the blank lines using some form of macro? Cells A1:A6 contain the data. Cell A2 will always be populated, but the remaining 5 can be blank Sample A1 - Address line 1 A2 - A3 - Town A4 - A5 - A6 - County In this sample I would like rows 2, 4 & 5 to be deleted, returning A1 - Address line 1 A3 - Town A6 - County Thanks for any help on this one |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Delete all blank rows... | Excel Discussion (Misc queries) | |||
Delete blank rows | Excel Programming | |||
Delete blank row only if 2 consecutive blank rows | Excel Programming |