delete empty rows

[hans]

Is there a simple way to delete all empy rows in a range?

I want to delete all empty row in a range of a1:d2000

Greetings Hans

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows