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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet references in code?
Try
ThisWorkbook.Sheets(2).Activate you can also eliminate the ThisWorkbook (it is implied) Sheets(2).Activate -- If this helps, please remember to click yes. "Bassman62" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet references in code?
if the name of the sheet has been changed in VBA then just the name will work
Sheet2.activate Keep in mind that the code name for the sheet and the name that appears on the sheet tab may not be the same. -- If this helps, please remember to click yes. "Bassman62" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet references in code?
Thanks for the reply.
I'd really like to use the sheet code name as the index will not follow if the sheets are rearranged. Also, I'd like to know how to refer to the sheet code name of a project that is not the ActiveWorkbook. Thanks. "Paul C" wrote in message ... Try ThisWorkbook.Sheets(2).Activate you can also eliminate the ThisWorkbook (it is implied) Sheets(2).Activate -- If this helps, please remember to click yes. "Bassman62" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet references in code?
Thanks Paul.
After more research, I think that I cannot refer to sheet code names outside of the active workbook. Thanks again for the prompt reply. "Paul C" wrote in message ... if the name of the sheet has been changed in VBA then just the name will work Sheet2.activate Keep in mind that the code name for the sheet and the name that appears on the sheet tab may not be the same. -- If this helps, please remember to click yes. "Bassman62" wrote: 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. |
Reply |
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 |