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