"I'm not quite clear where you are copying from, and to...
You start with Workbook1 open, which contains your code.
You want to:
- open Workbook2
- copy some values from the existing worksheet in Workbook2 (which has a variable name), to a new sheet in Workbook2
- rename both worksheets in Workbook2
- close Workbook2
Is that correct? "
Code is currently stored in a personal workbook...different issue for a different day.
Workbook1 has the variable name and worksheet. Workbook2 is opened,copied, and pasted into Workbook1. Sheet pasted into WB1 to be renamed "Sheet2." Variable worksheet to be named "Sheet1."
Bookmarks