Delete blank rows?

[ksnapp]

How would I write a sub that deletes empty rows? I have been reading
books on VBA and have yet to make anything useful to me, please help

regards

 

[Frank Kabel]

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

 

[ksnapp]

One Million Thankyou