R
Robert Crandal
I have one sheet in my workbook named "Work Data".
If this sheet is active, then the following expression
Application.ActiveSheet.Name
.... will return a string of "Work Data". However, I don't
want the name of the string in the sheet tab, I want the name from
my VBA project window (named Sheet1). How can I retrieve
the VBA name of my sheet??
thank u
If this sheet is active, then the following expression
Application.ActiveSheet.Name
.... will return a string of "Work Data". However, I don't
want the name of the string in the sheet tab, I want the name from
my VBA project window (named Sheet1). How can I retrieve
the VBA name of my sheet??
thank u