Thread
:
simple help needed please
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
simple help needed please
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/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]