Thanks Barb, I had tried doing from within a VB macro but couldn't figure
out how to call the macro by invoking a function. I know I can invoke the
macro from a form but I don't want to start putting buttons or other form
elements on the worksheet.

Steve

"Barb Reinhardt" wrote in message
...
I've seen some VB code that does this, but can't seem to find it right
now. Try doing a Google search for it.

"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