Delete rows with Start date greater than 30 days

Hi

I am new to VBA programming. I am looking to add a macro that does as below:

compares the start date if it is greater than 30 days, delete the entire row.

Please find attached the sample datasheet.

Thanks

Hi try dis code in sample file

Please Login or Register  to view this content.

option:

Please Login or Register  to view this content.

What are D2 and C2 here???? IF this is calculation the diffrence between start and finish dates, thats not what I wanted. I wanted to see if the start date which is column C is older than 30 days then I wanted to delete the entire row.

Please advice, thanks

ok, so I assume we compare today's date. Then it could be done this way:

Please Login or Register  to view this content.

THanks very much, its working great