can i put a sheet name in a cell on excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hello Bob
ShName = [D2]
Sheets(ShName).Activate

HTH
Cordially
Pascal
 
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 (e-mail address removed)> 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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
problems getting this macro to work 23
problem with fractions to decimal 1
How do i collate data from different sheets in one sheet? 8
Sheet Names and Auto-calculation 2
Navigate in a big worksheet 4
Excel, assign cells in multiple worksheets from one sheet 1

Back
Top