| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Sheet# Sheet Name
I notice in the VBA editor in the VBA project window there is always a Sheet#
and then the Sheet Name. For example: I change the name on Sheet2 to "Journal" then in the VBA Project it wil show Sheet2 (Journal). If in a macro I write: MsgBox ActiveSheet.Name It will return 'Journal' if I am in that sheet. Question: I do I return to a variable the original name of the sheet that appears in the VBA project window? Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet selected, automatic return to top of sheet | Excel Worksheet Functions | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
| How can I cause a cell to return the sheet name i.e. sheet 1? | Excel Worksheet Functions | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Threaded Mode
