inserting the worksheets name into a cell

[a94andwi]

Hello.

I want to insert the current active worksheet name into one cell in th
active worksheet.
How do I do that?
I guess it might be something like =[worksheet......] but am I wrong.

Please help

 

[Dave Peterson]

One way:
http://contextures.com/xlfaqFun.html#SheetName
From Debra Dalgleish's site.

Hello.

I want to insert the current active worksheet name into one cell in the
active worksheet.
How do I do that?
I guess it might be something like =[worksheet......] but am I wrong.

Please help?