G
Guest
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
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