Macro to Retain dates in a range

[Howardc1001]

i have the start date in D1 and the End Date in C1

I need a macro to retain all the dates in Col A the fall between the start date and end date and to delete the rows containing dates that fall outside this range


I have attached sample data


it would be appreciated if someone could kindly assist me

[Artik]

This can be done without a macro.
See the attachment. I used Advanced Filter.
The filter criterion can be specified in two different ways. Either the range C1:C3 or D1:D2. After filtering, select the visible rows and delete them.

Artik

[Howardc1001]

Thanks Artik. The advanced filter works well on your workbook

However, When I deteted the visible row, the hidden rows are also deleted

Please advise how to prevent this

[Artik]

I don't think so. You probably didn't clear the Advanced Filter after removing the visible rows. Use the "Clear" icon near to the "Filter" icon.

Artik

[Howardc1001]

Thanks or the reply. I did ascertain before you replied that I had to clear the filter

once again thanks for all your help