copy entiresheet fro 1 workbook to an existing work book error: invalid or unqualified ref

[Lconner]

My code is :

Please Login or Register  to view this content.

I am having trouble with the copy command. I am trying to copy sheet1 from for_macro_copy_test.xlsx to after sheet 1 in/of macro_enabled_all_valve_ex.xlsm. Currently I am getting the error message: invalid or unqualified reference and the .Workbook of .Workbook("macro_enabled_all_valve_ex.xlsm").Worksheet("Sheet1") is highlighted. What I have now seems like the correct syntax. Can you pleas tell me what the problem is and how to fix it?

also, is it going to be problematic for both the copy sheet and the sheet the copy is inserted after have the same name?

Lconner

[Cheetahke]

Hi,

There is a dot that need to be removed.
You can try this:

Please Login or Register  to view this content.

[Lconner]

when I try your code i got compilation error sud of function not defined and the workbook of Workbook("macro_enabled_all_valve_ex.xlsm").Worksheet("Sheet1") was highlighted. Any other ideas?

[Cheetahke]

Maybe this?

Please Login or Register  to view this content.

[Lconner]

thank you so much that worked!