Excel Function or VBA code for worksheet's name

H

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