Dele rows

[kkondrat1]

Newbie-

Hello, I am currently learning VB.

I receive a report everyday in Excel that needs rows deleted.

I have a date column on the report, so some of the cells do not contai
dates and some cells do contain dates, I need all the rows deleted tha
do not contain dates.

any help would be great, thanks

 

[Frank Kabel]

Hi
one way (manually):
- Apply an autofilter for your data
- filter al blank rows
- delete the blank rows

A VBA solution can be found at
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

Frank

 

[kkondrat1]

Very Cool, Thanks Fran