Retreive worksheet name ...

[H.B.]

Hi,

Is there a formula to retreive the current worksheet name in excel?

Thanks,

Hugo

 

[Andy Brown]

Is there a formula to retreive the current worksheet name in excel?

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

The file must be saved first for this to work.

Rgds,
Andy

 

[Jason Morin]

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

Note: wb must saved to work.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try one of the following formulas (note: the workbook has
to be save
before). Just use the formulas as they are shown (don't
replace 'filename' with anything else)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-
1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("file
name",A1),1))