using worksheet name

D

Deborah J Doyle

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
 
C

Chip Pearson

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"
<[email protected]>
wrote in message
news:D[email protected]...
 
Top