| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet references in code?
I have some old code that refers to sheet names and I'd like to change these
to the sheet code names. However, apparently code names are objects of a different type than sheet Names. Here's an example of what I'm trying to do: Change ThisWorkbook.Sheets("Report").Activate To ThisWorkbook.Sheet2.Activate 'Error: Method or Data Member not found. This seems elementary but I can't seem to get the syntax correct. How can I refence a code name of a particula workbook? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to change code in a sheet and workbook module | Excel Programming | |||
| Import data using QueryTable somehow change sheet cells references | Excel Programming | |||
| formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
| See code enclosed - Convert to formulas with absolute reference inculding the sheet references! | Excel Programming | |||
| Code to change references | Excel Programming | |||
Threaded Mode
