Worksheets("MyName").select

[CLR]

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

 

[Norman Jones]

Hi Chuck,

Try deleting the quotes:

Worksheets(MyName).select

Copy Destination:=Worksheets(MyName).Range("A1")

 

[IanKR]

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.......

If MyName is a variable, exclude the "" - viz:

Worksheets(MyName).select
and
Copy Destination:=Worksheets(MyName).Range("A1")

 

[Nick]

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

Dont use quotes

 

[CLR]

So cool when you "know how"...<G>

Thanks Norman

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Got it..........thanks IanKR

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Got it...........thanks Nick

Vaya con Dios,
Chuck, CABGx3

 

[Tom Ogilvy]

Not as exciting when you hear it the 3rd time <g>

 

[CLR]

True Tom.....LOL, but I spent a couple hours anguishing over that problem
before asking, and then it went so well with the "right" answer.......I just
love it when a plan comes together......I'd be in a heap of doo-doo with out
the help I get here.

Vaya con Dios,
Chuck, CABGx3