can i put a sheet name in a cell on excell

B

Bob Rogers

i am trying to put a sheet name into a cell and use a command button to
activate it. Sheets([D2]).activate does not work for some reason, has anyone
got any other ideas?
 
J

Jim May

or use the formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

HTH


papou said:
Hello Bob
ShName = [D2]
Sheets(ShName).Activate

HTH
Cordially
Pascal

"Bob Rogers" <Bob [email protected]> a écrit dans le message
de news:[email protected]...
i am trying to put a sheet name into a cell and use a command button to
activate it. Sheets([D2]).activate does not work for some reason, has anyone
got any other ideas?
Click to expand...
Click to expand...
 
Top