select sheet names from cell references ??

[danno_mbk]

Hi,
does anyone know if it is posible to select a sheet using a cell reference ?

eg if the sheet was called Feb 04 test, can I have the month in cell A1 the year in A2 then the word test in A3.
combine the three together :
in cell A4 = A1&" "&A2&" " &A3
copy and paste special
in to A5
then use cell a5 as a sheet reference. so I can say in my code:
sheets(" cell ref A5").select ?????

thanks

Dan

 

[macleanb]

taKE A LOOK AT THE INDIRECT FUNCTION - WHICH DOES THIS. iTS A VOLTAILE (woops sorry for shouting) function so can impact performance.

Sory - wrong garden path there...

 

[R_Stephens]

Hi there,

Yes you can do this, the coding would look like

Sheets(Range("A5").Value).Select

Hope this helps

Richard

 

[danno_mbk]

thanks guys

 

[danno_mbk]

Additonal:

sorry forgot to say that I want to select a sheet in another workbook.

how do I get it to choose the workbook and the sheet ? when I am in another workbook ?eg

workbook 1 holds in cell A5 the sheet name
Sheets(Range("A5").Value).Select
workbook 2 has the actual sheet name
(i have exhausted all my ideas)
elp....