Hi Anne, thanks for the fast response. Your solution took me 30 seconds to
implement & 30 minutes to understand! :)
Steve
"Anne Troy" wrote in message
news:cf71d$42c1daf3$97c5108d$31392@allthenewsgroup s.com...
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