A
Al
I want to copy values from my active workbook to a series of open, inactive
workbooks. I know this can be done by explicitly naming each destination
workbook:
Cells(1,1).Copy
Destination:=Workbooks(“Wkbk1.xlsâ€).Sheets(“Nameâ€).Range("A1")
In my application, I want to synthesize the workbook names as variables from
values in a master file and replace the workbook name “Wkbk.xls†with each
variable needed. If I try to just replace the name with a variable, I get a
“Subscript out of range†error. How can I do this without having to activate
each workbook in turn?
workbooks. I know this can be done by explicitly naming each destination
workbook:
Cells(1,1).Copy
Destination:=Workbooks(“Wkbk1.xlsâ€).Sheets(“Nameâ€).Range("A1")
In my application, I want to synthesize the workbook names as variables from
values in a master file and replace the workbook name “Wkbk.xls†with each
variable needed. If I try to just replace the name with a variable, I get a
“Subscript out of range†error. How can I do this without having to activate
each workbook in turn?