Deleting blank lines in a range
 

Hi Fred,

Delete Rows section found in the middle of

Delete Cells/Rows in Range, based on empty cells, or cells with specific values
http://www.mvps.org/dmcritchie/excel/delempty.htm#rows

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fred Taylor" wrote in message ...
Hello,

I'm, trying to find a function/ or write a macro that will delete ALL empty
lines in a range.

Does anybody have any idea how I could do this?

Thanks