Excel VBA - Using variable for wksht name

[swtrader]

Dim S As String
S = ActiveSheet.Name

-- other code, going to different worksheet --

'trying to return to S

Sheets(S).Select -- doesn't work

What does work?

Thanks.

 

[SkipVought]

Hi,

The way I would do it...

Dim sSheetName As String
sSheetName = ActiveSheet.Name

' -- other code, going to different worksheet --

'trying to return to S

Sheets(sSheetName).Activate

But using the Select and Activate methods is not recommended in most cases. faq707-4105

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}