Excel Function or VBA code for worksheet's name
 

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 :confused:


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

Excel Function or VBA code for worksheet's name
 

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 :confused:

Excel Function or VBA code for worksheet's name
 

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

Hendra


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