I'm not sure what you're after, but this may help:

http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
"Barb R." wrote:

I'd like to use the sheet tab name in a formula. I'd actually like to fill
in some fields including the sheet tab name. Is there an easy way to do
this?

Thanks in advance.

Barb Reinhardt