Sheet Name
 

Anyone got an idea for a formula that can identify the sheet name that
the formula is written in? 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.

Thanks
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=551756

Sheet Name
 

=Cell("Filename",A1)

--
HTH

Bob Phillips

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

"chalky" wrote in
message ...

Anyone got an idea for a formula that can identify the sheet name that
the formula is written in? 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.

Thanks
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=551756

Sheet Name
 

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

Sheet Name
 

perfect - thanks!


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=551756