| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get name of active sheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send Data From Active Sheet to Closed Sheet on Network | Excel Programming | |||
| active sheet is 'slow' to be active | Excel Programming | |||
| I need to sort an active sheet using the col of the active cell | Excel Programming | |||
| Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Threaded Mode
