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


---
Message posted from http://www.ExcelForum.com/

ian

Select a column and EditGo ToSpecialBlanksOK

With blank rows selected EditDeleteEntire Row.

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

Gord Dibben Excel MVP

On Wed, 17 Dec 2003 15:11:35 -0600, ian123
wrote:

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


---
Message posted from http://www.ExcelForum.com/

You could just sort the data then the empty rows will be at the bottom!

--
Regards,
Rocky McKinley


"ian123" wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

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

--
Don Guillett
SalesAid Software

"ian123" wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

columns(1).SpecialCells(xlBlanks).entireRow.Delete

--
Regards,
Tom Ogilvy

ian123 wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/