Excel Function or VBA code for worksheet's name

[hendra]

Dear all Excel experts ...

I wonder whether there is an Excel built-in function or VBA code
(please give me an example code and how to create it) for showing
worksheet's name (text) in a cell?
Let say I have cell A1. So I want A1 cell will refer to "sheet1"
worksheet's name (worksheet tab's name).
And if I change "sheet1" name to "john", the cell A1 will change to
"john".

Thank so much in advance ...

I look forward to getting a quick response ....


Hendra

 

[Gord Dibben]

No need for VBA.

See Bob Phillips' site for worksheet formulas.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

 

[hendra]

Thank so much for your help Gord Dibben.
I really appreciate it.

Hendr