VBA Archive and Clear Range

Hello all.

I am having an issue with a code and I would appreciate any help or guidance. I have this code that is supposed to:

1. Copy row with "True" in Column Y on the "Main" sheet
2. Paste data in first empty row on "Archive" sheet
3. Clear range A:X on original row (not deleting it, just erasing content)
4. Message Box

In this form it is archiving (moving to other sheet and erasing the data) of all the data on the "Main" sheet. It is supposed to just perform this function on the row that has "True". Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thank you for the code. I appreciate your time. It is actually erroring out on line

Please Login or Register  to view this content.

The error is "Run-time error '1004': Copy method of Range class failed". I tried to remove the (Target) area and replace it with the line above it but its the same error?

Perfect. This worked just like I needed. Just added a +1 to the row number and it is perfect. Thank you so much for the help.