Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using worksheet codenames
I am trying to write everything using worksheet codenames instead of tabnames but am having trouble when these are not hard coded
I have a sheet1 (codename) with tabname "dog"; sheet2 (codename) with tabname "cat";sheet3 (codename) with tabname "mouse";sheet4 (codename) with tabname "ferret should I not be able to write sheet2.copy after := sheet I would expect to get sheet5 (codename) with tabname "cat (2) similarly if I have a string variable cnam cname = "sheet2 cname.copy after :=cname should do the same thin As I write this maybe cname has to to be a worksheet object? How would that work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loops with sheet codenames | Excel Discussion (Misc queries) | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
From my Addin, referring to activeworkbook's sheets by their codenames | Excel Programming | |||
strange worksheet.codenames in XL97 | Excel Programming |