Deleting a row where a cell contains a date in a column

**macrohelp5** · 09-05-2012, 03:37 PM

Hello,

I am a novice when it comes to macros and I can't seem to solve my issue. I have a macro already set to modify columns, etc and at the end I need it to search for a certain date in a certain column and delete the entire row if the criteria is met. In my worksheet, I need it to search column N (for the entire worksheet) for a date that has a year of 1900. If 1900 is found in column N, regardless of month or day, it should delete the entire row. Currently an example of how the data looks in column N is 1900/01/01, but some formats include a time stamp. I believe my issue is with the way the date is formatted. I have tried the following but it is not deleting anything.

Please Login or Register  to view this content.

I have attached a sheet that has how the dates appear so you can see the formatting of the dates.date format.xlsx

Any help is greatly appreciated. Thanks.

**JieJenn** · 09-05-2012, 03:54 PM

I haven't try it yet, but give it a try

Please Login or Register  to view this content.

**Cutter** · 09-05-2012, 07:50 PM

@ macrohelp5

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.