Copy selection, run-time error 1004 issue

Hey everyone, I'm hoping for some help with an issue I am having. What I am trying to do is copy multiple ranges not next to eachother and paste them into a different tab in the workbook. Here is the code that is having the issue:

Please Login or Register  to view this content.

When it gets to the Selection.Copy part it errors out as Run-Time error 1004 Command cannot be used on multiple selections. What I don't understand is I can use the record macro button, do the exact same copy and paste exercise in the same file without getting an error about the multiple selections. Does anyone know why I am getting this and if there is a way around it? Any help would be greatly appreciated, thanks!

Please Login or Register  to view this content.

You left out the "

Sorry yeah that was just left out when posting it on the forum. In the code it's there so not causing the issue here.

When I use use your suggested code with ".Copy" I still get the same error message.

No, I have tested both lines and work. The error may be on the sheet name.

Please Login or Register  to view this content.

Try:

Changing this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Not sure what to tell you AB33, when I run it I still get the error. As for the sheet name, it doesn't have a problem selecting the tab and doing things in it, it's just when you try to copy so I don't know what you mean by the error being in the sheet name.

Thanks for the reply John H. Davis, it errors out at the ".Copy" part and doesn't even get to the SETT sheet. I'm not sure if there is some external piece that is not allowing the ".Copy" or what. The tab is unlocked so is there something else that restricts that?

Please change this line
Sheets(TABNM).
INTO

Sheets("sheet1") or another proper sheet name

for testing and see if you get an error

Thanks AB33, tried it but still getting the error. At this point I'm going to have to break them out individually into 4 copy and paste commands so this won't be an issue.

Please attach a sample and will be solved quickly.