simple help needed please

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

i often get data with lots of blank rows between the data at random
intervals which i'd like to eliminate.

Does anyone know a good macro for deleting rows that can handle
"overlapping selections"- ie where the are groups of rows of data, then
rows of empty cells, then data rows, then empty for etc etc etc!

Thanks very much for any help
 
ian

Select a column and Edit>Go To>Special>Blanks>OK

With blank rows selected Edit>Delete>Entire Row.

Turn on the Macro Recorder while you're doing this.

Gord Dibben Excel MVP
 
Wouldn't the easiest would be sort by blanks and just delete all blanks.
Or use a specialcells(xlblanks) macro to delte
 
Back
Top