If you do not use an index number to identify a specific workbook or
worksheet then you must use the name of the workbook or worksheet.
All names are strings except for those referring to range objects,
so enclose info in quotation marks...
Worksheets("info")
'--
Jim Cone


"hawki"
wrote in message
I get the following error. Run time error "9". Subscript out of range.
--
l-hawk


"Jim Cone" wrote:
And what is the error you get?
Jim Cone


"hawki"
wrote in message
The procedure stops at the following line.

Workbooks("info.xls").Worksheets(info).Range("a1") .End(xlDown).Offset(1,
0).PasteSpecial xlPasteValues
--
l-hawk