Q about making a function
I agree that you should just use a formula. However, for future reference,
to update a function, you should use the 'Application.Volatile' Method. See
HELP.
--------------------------
Volatile Method Example
This example marks the user-defined function "My_Func" as volatile. The
function will be recalculated whenever calculation occurs in any cells on the
worksheet on which this function appears.
Function My_Func()
Application.Volatile
'
' Remainder of the function
'
End Function
--------------------------
"Microsoft Forum" wrote:
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.
|