| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.Name
Hello,
I appreciate if someone can help me with a function that grabs only a portion of the sheet name. For example, I'm using ActiveCell = ActiveSheet.Name, then I'm using formula colname =right(mycell,5) is there a way that I don't have to put the name of the sheet in the SS, just grab it directly from the tab and storage it ? Thank you, -- Thank you... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? | Excel Programming | |||
| Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
| ActiveSheet.Name? | Excel Programming | |||
| ActiveSheet | Excel Programming | |||
| ActiveSheet | Excel Programming | |||
Threaded Mode
