Worksheets("MyName").select
So cool when you "know how"...<G
Thanks Norman
Vaya con Dios,
Chuck, CABGx3
"Norman Jones" wrote:
Hi Chuck,
Try deleting the quotes:
Worksheets(MyName).select
Copy Destination:=Worksheets(MyName).Range("A1")
---
Regards,
Norman
"CLR" wrote in message
...
Hi All........
Having trouble here with the lines of code
Worksheets("MyName").select
and
Copy Destination:=Worksheets("MyName").Range("A1")
where MyName is a variable, declared and set earlier.......I get "Runtime
error 9, Subscript out of range" error and macro won't pass that point.
How else might I be able to refer to that sheet whose name changes as the
macro goes along.......
TIA
Vaya con Dios,
Chuck, CABGx3
|