Thread: accessing worksheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
greg greg is offline
external usenet poster
  
Posts: 59
Default accessing worksheets
thanks for the help


"Bob Phillips" wrote in message
...
Yes you can use CodeName

Sheet2.Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greg" wrote in message
...
Hello,

I have a question about referencing a specific sheet.

I see you can do this:

ThisWorkbook.Worksheets("MySpecialSheet").Select

Or

ThisWorkbook.Worksheets(2).Select

However, if the user changes the name of the sheet to "MySpecialSheet2"
or
re-order the tabs you cannot use those.

I see there is a property CodeName. Which always has the default
"Sheet<x"
name.

Can this be used?

Is there some other way to identify the sheet?



Thanks








Reply With QuoteReply With Quote