Function to return the current Worksheet name?

[Steve]

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

 

[Anne Troy]

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

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

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Barb Reinhardt]

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]

Hi Anne, thanks for the fast response. Your solution took me 30 seconds to
implement & 30 minutes to understand!

Steve

 

[Steve]

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

 

[Bob Phillips]

Maybe something like this

Function ThisSheet() As String
ThisSheet = Application.Caller.Parent.Name
End Function

called from a worksheet with =ThisSheet()

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steve]

Thanks Bob, amazing how much easier things become when exact syntax is
available.

Steve