Set Variable Equal to Specific Sheet

[Larry R Harrison Jr]

I have Excel 2003. I am trying to activate a given worksheet (which is
already open as a "window"); its name is in a string variable named stX.

To activate it, I tried this:

Dim stSt as Worksheet
set stSt=Worksheet(stX)
Windows(stSt).Activate

But I get "subscript out of range."

I know I'm close just can't quite get it. And searches in Google aren't
finding me anything; I know there MUST be something in there.

Tips?

LRH

 

[Stephan Kassanke]

I have Excel 2003. I am trying to activate a given worksheet (which is
already open as a "window"); its name is in a string variable named stX.

To activate it, I tried this:

Dim stSt as Worksheet
set stSt=Worksheet(stX)
Windows(stSt).Activate

But I get "subscript out of range."

I know I'm close just can't quite get it. And searches in Google aren't
finding me anything; I know there MUST be something in there.

Tips?

LRH

Larry,

try Worksheets(stX)

cheers,
Stephan

 

[Stephan Kassanke]

In addition to the previous post: stSt is already an object variable, the
last line should read: stst.activate

Stephan