Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just spend 20-30 minutes going thru the Google Archive
Looking for an answer to my subject line After 19-29 minutes of confusion, I just came up with the below code; It seems to work -- but I'm asking "Is there a "gotch-Cha" Associated with it? Seems simple enough - In the Interface my 3rd of 3 sheets shows "Page3" -- but of course in the VBA Properties Window (Name) box I show MySheet3codename Sub Selectsheettest() MySheet3codename.Activate Range("B4").Value = "hello - You made it !!" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
string to codename | Excel Discussion (Misc queries) | |||
change sheet codename | Excel Programming | |||
codename help | Excel Programming | |||
Selecting a sheet by codename | Excel Programming | |||
Using sheet codename problems | Excel Programming |