Looping through & cutting and pasting values between two dates

[ShaliniGomes]

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

[Leith Ross]

Hello ShaliniGomes,

I don't see anything wrong with the macro syntax. If the values in the cells were not valid dates you would receive a type mismatch error.

You should post a copy of the workbook for further review.

[ShaliniGomes]

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.

[Leith Ross]

Hello ShaliniGomes,

Did you really want to create a separate worksheet for each date?

[Leith Ross]

Hello ShaliniGomes,

I did find the error. in your code you have If .Cell(i, 1).Value < StartDate Then

It should be If .Cells(i, 1).Value < StartDate Then

[ShaliniGomes]

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.

[Leith Ross]

Hello ShaliniGomes,

This worked for me.

Please Login or Register  to view this content.

[ShaliniGomes]

Thankk you so much!!! Amazing

[ShaliniGomes]

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?

[Leith Ross]

Hello ShaliniGomes,

The macro will now check if the contents of the cells in column "A" are dates. If the cell is not a date then it is ignored.

Please Login or Register  to view this content.