Try this, Steve:
http://www.officearticles.com/excel/...ft_e xcel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Steve" wrote in message
...
Is there a function that returns the current Worksheet name? I am creating
multiple Worksheets by Copying and Pasting the same "template" sheet and
would like as much of the worksheet specific text as possible to be
generated automatically.

Thanks, Steve