Is there a way to retrieve the name of the current worksheet in Excel VB?

Question

I need a way to move the name of the currently selected worksheet into a character string.  I need to do this so that I can switch back to the worksheet after switching to another one.

lantere · Accepted Answer

You can use:
 ActiveSheet.Name

This should work to place it in a string:
 strWSName = ActiveSheet.Name

 MsgBox strWSName
will give a Message Box with the Active Sheet Name.

Is there a way to retrieve the name of the current worksheet in Excel VB?

Related Questions

Trending Questions