***Worksheet Name***

[cafeaulait]

Hi Guys

I am trying to pull worksheet name ie "Sheet1"!

This forumula only pulls Sheet1"! It won't allow me to insert " at the beginning.

=""&RIGHT(CELL("FILENAME"),LEN(CELL("FILENAME"))-FIND("]",CELL("FILENAME")))&"!"""

Many thanks
Genevieve

 

[VoG]

Try

=CHAR(34)&RIGHT(CELL("FILENAME"),LEN(CELL("FILENAME"))-FIND("]",CELL("FILENAME")))&"!"""

 

[cafeaulait]

Thanks I just tried this it returned VALUE# !

 

[VoG]

The workbook must be saved for that formula to work.

 

[cafeaulait]

oh yes thanks! it's working