Dele rows
 

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

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

Dele rows
 

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/

Dele rows
 

Very Cool, Thanks Fran

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