Looping through & cutting and pasting values between two dates

Hi,

I am trying to cut all rows with the date less than 2 days older than the current date. Cut and paste it into a new worksheet in same workbook and save it into a specific folder.

Here is my code:

Please Login or Register  to view this content.

I am getting an error on the line :

Please Login or Register  to view this content.

Saying Object doesn't support this property or method.

Any ideas how I can solve this?

Thanks

Dummy Workbk.xlsm

Hi this is a dummy workbook. So I want only the dates from current date to current date-2 to be cut and pasted into new worksheet.

Thanks for your help.

Thank you Leith Ross,

I have another error:

Please Login or Register  to view this content.

on line

Please Login or Register  to view this content.

Thankk you so much!!! Amazing

Hi so I have run into an unexpected problem.

with this code

Please Login or Register  to view this content.

It gives a type error when I have the word "1 target" on column A more than once. I have the word "1 target" about 1000 times down column A and then the date begins on column A. So I want the code to ignore the word "1 target". I put it into the if statement and said

Please Login or Register  to view this content.

but it gave me an error.

Any help please?