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/