I'm new to VBA and have a sub that creates a new worksheet with the
name specified in a input box. I would like to switch back to my
original worksheet after the creating the new one and I'm lost. I
would also like to switch to any worksheet just by entering the WS
name in an input box. Appreciate any help.

Thanks

Something like:


Dim sSheetNameOriginal As String

sSheetNameOriginal = ActiveSheet.Name

'your code

Sheets(sSheetNameOriginal).Select 'to go back



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"JR" wrote:

I'm new to VBA and have a sub that creates a new worksheet with the
name specified in a input box. I would like to switch back to my
original worksheet after the creating the new one and I'm lost. I
would also like to switch to any worksheet just by entering the WS
name in an input box. Appreciate any help.

Thanks