Hi Everyone

I have defined a self-written function within a module on a spreadsheet. The
logic works fine and the function returns the result I want when the entry

=functioname(parameters) is place in a cell.

However, if I change one of the parameter values in the spreadsheet itself,
the function does not automatically update the content of the cell in which
the function call is made. If I move the cursor to the cell, hit F2 and then
enter, it updates fine.

I have added a simple =SUM() function to the same sheet and any changes to
the source values for the SUM function update just fine.

I'm confused ... anyone have any ideas why the self-defined function isn't
udpating? I have checked the options sheet and it is set to Automatic
calculation and I don't know where else to look.

Thanks in advance for any replies.

Peter

Peter,

Can you show us the function?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter" wrote in message
...
Hi Everyone

I have defined a self-written function within a module on a spreadsheet.
The
logic works fine and the function returns the result I want when the entry

=functioname(parameters) is place in a cell.

However, if I change one of the parameter values in the spreadsheet
itself,
the function does not automatically update the content of the cell in
which
the function call is made. If I move the cursor to the cell, hit F2 and
then
enter, it updates fine.

I have added a simple =SUM() function to the same sheet and any changes to
the source values for the SUM function update just fine.

I'm confused ... anyone have any ideas why the self-defined function isn't
udpating? I have checked the options sheet and it is set to Automatic
calculation and I don't know where else to look.

Thanks in advance for any replies.

Peter

Put the line

Application.Volatile


inside your function