No need for VBA.

See Bob Phillips' site for worksheet formulas.

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


Gord Dibben MS Excel MVP

On Sun, 13 Aug 2006 21:57:43 -0400, hendra
wrote:


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