Using Cell Contents to Select Worksheet with Same Name as Cell Con
hiya
two comments
1) have a look at and a play with the INDIRECT formula from the excel help.
(you can have in Cell A1 a text saying " sheet2!A4 ".
And if you use =INDIRECT(A1) excel will return the value from sheet 2 cell A4.
I think this might be what you mean.
2) If you really mean activating sheets, it needs to be done with code like
this.
Sub allllen()
Sheets(Range("B2").Value).Activate
End Sub
--
Allllen
--
Allllen
"Alan Sexter" wrote:
I am a quantitative analyst who is the leader of our department's Excel users
group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,
Wisconsin). I have a friend who is a former co-worker in my department, but
is now a senior credit analyst with a company in Chicago.
If possible, this credit analyst would like to have Excel take the contents
of a cell in the workbook, and use it to select a worksheet (in that same
workbook) that has the same name as the contents or value of that cell. This
seems to be a "twist" on the topic of automated worksheet names that has
generated several postings. Any help will be greatly appreciated by both of
us. Thanks for any help that can be provided!
|