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


--
hendra
------------------------------------------------------------------------
hendra's Profile: http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=571237