| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to dynamically get sheet name
Greetings,
I'm trying dynamically store into a variable the name of the active sheet. I've tried various combination (based on my less than expert experience with VBA code). Any light shed would be greatly appreciated. regards, CG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to dynamically get sheet name
Maybe
MyName = ActiveSheet.Name Mike "LetMeDoIt" wrote: Greetings, I'm trying dynamically store into a variable the name of the active sheet. I've tried various combination (based on my less than expert experience with VBA code). Any light shed would be greatly appreciated. regards, CG |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to dynamically get sheet name
thank you. that was simple.
regards, CG |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to dynamically get sheet name
Glad I could help
"LetMeDoIt" wrote: thank you. that was simple. regards, CG |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to dynamically get sheet name
I've done this (and not used the name)
Dim aWS as Excel.worksheet Set aWS = ActiveSheet Anywhere you've use Activesheet, replace with aWS. aWS.cells(1,1).value = ... aws.range("myRange").address aWS.name aWS.Parent.Name <~~workbook name -- HTH, Barb Reinhardt "LetMeDoIt" wrote: Greetings, I'm trying dynamically store into a variable the name of the active sheet. I've tried various combination (based on my less than expert experience with VBA code). Any light shed would be greatly appreciated. regards, CG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet name, creating dynamically to be used in formula.... | Excel Programming | |||
| dynamically select sheet | Excel Programming | |||
| Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
| creating a combobox dynamically on an excel sheet | New Users to Excel | |||
| Dynamically display subset rows from one sheet in another sheet? | Excel Programming | |||
Linear Mode
