How to retrieve the sheet name?
 

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

How to retrieve the sheet name?
 

On 8 avr, 23:30, Eric wrote:
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

How to retrieve the sheet name?
 

Hi Eric,

The the following...

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



"Eric" wrote:

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