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/deleti...eleteBlankRows

Frank

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
contain dates and some cells do contain dates, I need all the rows
deleted that do not contain dates.

any help would be great, thanks.


---
Message posted from http://www.ExcelForum.com/