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?

--
Al C