Hi all,

I have written a function which displays a current sheet name in a cell. It
is very simple and it works fine.

However, I have a question. Suppose the function is called "SheetName" and
the current sheet is named "Sheet1".

I put "=SheetName()" in a cell and it properly display "Sheet1". However, if
I change the sheet name, then the function won't automatically do the
update. Any way to do the automation? Thanks a lot.

Frederick Chow
Hong Kong.