How to retrieve the sheet name?

E

Eric

Does anyone have any suggestions on how to retrieve the sheet name?
For example, the sheet is named 'Date", I would like to retrieve its name
into cell A1, does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
N

new1

Does anyone have any suggestions on how to retrieve the sheet name?
For example, the sheet is named 'Date", I would like to retrieve its name
into cell A1, does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Hello,

You can write a macro that automaticly writes the active sheet name in
the A1 cell.
In VBA it can be coded like this :

Sub getSheetNameInA1()
ActiveSheet.Range("A1") .value=ActiveSheet.Name
End Sub

Caution: it will overload the previous data in cell "A1"
You can launch this macro via the "Tools / Macros menu"

Hope this helps

new1@[no/spam]realce.net
 
D

Dinomatic

Hi Eric,

The the following...

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

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

Top