Sheet Name

[chalky]

Anyone got an idea for a formula that can identify the sheet name tha
the formula is written in? i have used =CELL("FILENAME") for a tas
similar to this but this will only idenify the sheet that the last sav
was made in and i need to replicate this formula across 15 sheets.

Thanks
Chri

 

[Bob Phillips]

=Cell("Filename",A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Jan Karel Pieterse]

Hi Chalky,

i have used =CELL("FILENAME") for a task
similar to this but this will only idenify the sheet that the last save
was made in and i need to replicate this formula across 15 sheets.

Use =CELL("FILENAME",A1).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[chalky]

perfect - thanks!