| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Codenames
That did help thank you Per :-)
-- Thank you Annie "Per Jessen" wrote: Hi Annie With a worksheet level sheet name the syntax is: Worksheets("Sheet1").Select With a VBA level code names the syntas is: Sheet1.Select Hopes this helps. .... Per "Annie Whitley" skrev i meddelelsen ... Hi everyone, I've got a workbook in which other users may rename sheets so I want to change all tab names to codenames in VBA modules. I've read that I can do it using Find/Replace in the VBE but what I wanted to know is whether I need to tell it I'm using the codename for sheets. If I have to (or should) how would I do it? -- Thank you Annie . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loops with sheet codenames | Excel Discussion (Misc queries) | |||
| Efficient use of sheet "codenames" | Excel Programming | |||
| Sheet CodeNames | Excel Programming | |||
| Use of Sheet CodeNames to Select Sheet in Different Workbook | Excel Programming | |||
| Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
