it's the last thing in =cell("filename") maybe you could use MID and RIGHT or
something to pick it out?

"ckane" wrote:

I have a worksheet with several tabs. Each tab is a different persons name.
Is there a way to have the name on the tab automatically show up in a
specific cell on the worksheet. Thank you!