Not transferring over to Archive.

[Cyberpawz]

For some reason, my code is not working, when it was before.

The code is this:

Please Login or Register  to view this content.

The place I am having an error is here:

Please Login or Register  to view this content.

Now I can't seem to understand why the error is happening. It was working Friday, now it's not at all.

Can someone give me a push in the right direction why this is happening?

Attached is the workbook.

[JieJenn]

Because your column Q is outside the "currentRegion" range. If Column Q and and current region are not intersecting, you will get an error unless you put Resume Next statement before the line. Change your code to

And you might want to be a little bit cautious with your parent-child relationship in your code.

Please Login or Register  to view this content.

[Cyberpawz]

Because your column Q is outside the "currentRegion" range. If Column Q and and current region are not intersecting, you will get an error unless you put Resume Next statement before the line. Change your code to

And you might want to be a little bit cautious with your parent-child relationship in your code.

Please Login or Register  to view this content.

The code works, but it's not transferring everything over.

[Cyberpawz]

The code is now getting an error here:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Here exactly.
Runtime Error 424.