worksheet names

[Phil]

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 B]

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]

Paul

Thanks alot. Exactly what I was after.

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

 

[Paul B]

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