function to get active worksheet name

[beachboy]

Hi,

Is there a function where I can get the name of an active worksheet?

 

[Al Chara]

In the mean time you can use the following formula:
=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")
_________________
Hope this helps.
Kind regards,<font size="5">^{<span style="text-decoration: overline">AL</span>}<u>_CHARA</u></font>
This message was edited by Al Chara on 2002-07-25 11:22

 

[Al Chara]

Goto INSERT|NAME|DEFINE
Type SheetName under "Names in workbook:"
Type =GET.CELL(5,A1) under "Refers to:"

Then go into a cell on your worksheet and type SheetName
It will return the Sheet name

I can't seem to find what I am looking forward. You can always try the following:

Goto INSERT|NAME|DEFINE
Type SheetName under "Names in workbook:"
Type =REPLACE(GET.DOCUMENT(1),1,FIND("]",GET.DOCUMENT(1)),"") under "Refers to:"

Then go into a cell on your worksheet and type SheetName
It will return the Sheet name

 

[Mohsin Khan]

Hi

i have use VBA function NM and can get the active sheet name in cell but please tell me how can i use it in a formula or in chart series then i can copy and paste my data on other sheets and it will take sheets name automatically on other sheets.
coz i have 40 sheets with same data and same charts i can edit my data simultaneously by grouping sheets but i am unable to edit charts please help.

 

[dotxl]

This thread has long been dormant but I created a Name (ThisWS) in the Name Manager with the following formula in the "Refers to:" section: =MID(CELL("filename",INDIRECT("A1")),FIND("]",CELL("filename",INDIRECT("A1")))+1,255).
Referring to ThisWS (as =ThisWS) in any sheet returns the sheet name of the sheet (not just the last sheet calculated). Hope this helps.

 

[sirplus]

This only seems to return the name of the sheet that was active at time name was set up

 

[dotxl]

This only seems to return the name of the sheet that was active at time name was set up

Not sure what you mean sirplus.