It is possible, using the worksheet functions, to extract the worksheet name?

If not, is there another way that shows this result automatically without
the need to run a macro?

Phil, have a look here for how to do it

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil" wrote in message
...
It is possible, using the worksheet functions, to extract the worksheet
name?

If not, is there another way that shows this result automatically without
the need to run a macro?

Paul

Thanks alot. Exactly what I was after.

"Paul B" wrote:

Phil, have a look here for how to do it

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil" wrote in message
...
It is possible, using the worksheet functions, to extract the worksheet
name?

If not, is there another way that shows this result automatically without
the need to run a macro?

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil" wrote in message
...
Paul

Thanks alot. Exactly what I was after.

"Paul B" wrote:

Phil, have a look here for how to do it

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil" wrote in message
...
It is possible, using the worksheet functions, to extract the worksheet
name?

If not, is there another way that shows this result automatically
without
the need to run a macro?