using worksheet name
 

Is there a way to use the name of a worksheet in a formula?

I would like to use the 'if' function and have one of the criteria be
the name of the worksheet.

Thanks


--
Deborah J Doyle
------------------------------------------------------------------------
Deborah J Doyle's Profile: http://www.excelforum.com/member.php...o&userid=33526
View this thread: http://www.excelforum.com/showthread...hreadid=533220

using worksheet name
 

The following formula will return the name of the worksheet on
which it appears.

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

Note that the file must have been saved to disk for the formula
to work. Also, leave the "filename" text intact -- do not
substitute the actual file name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Deborah J Doyle"
<Deborah.J.Doyle.26c0pa_1145148602.2042@excelfor um-nospam.com
wrote in message
news:Deborah.J.Doyle.26c0pa_1145148602.2042@excelf orum-nospam.com...

Is there a way to use the name of a worksheet in a formula?

I would like to use the 'if' function and have one of the
criteria be
the name of the worksheet.

Thanks


--
Deborah J Doyle
------------------------------------------------------------------------
Deborah J Doyle's Profile:
http://www.excelforum.com/member.php...o&userid=33526
View this thread:
http://www.excelforum.com/showthread...hreadid=533220

using worksheet name
 

THANKS!! the formula worked perfectly!


--
Deborah J Doyle
------------------------------------------------------------------------
Deborah J Doyle's Profile: http://www.excelforum.com/member.php...o&userid=33526
View this thread: http://www.excelforum.com/showthread...hreadid=533220