Use of sheet codename in codeline - How?
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
|