You should define what you mean by "empty". Do you mean blanks? Empty
strings (i.e., ="")? Cells with only spaces? Etc.

Alan Beban

Fred Taylor wrote:
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