Greetings:

I've written a UDF utilized in several cells , which if directed to
calculate essentially returns the value from another cell (each UDF is paired
with a different cell). The UDF can also be called by an event, which sets a
Static variable in the UDF then forces the target cell to calculate
(Target.Dirty). What was unexpected is that not just the target cell
calculates, virtually all cells that utilize the UDF re-calculate, regardless
of the fact that nothing has changed in their repective dependent cells.

Does anyone know what about this process is causing Excel to generate these
extraneous calculations?

Thanks.

Additional Information:

Apparently not all cells utilizing the UDF are re-calculated, only those on
or below the row of the target cell.

:-)


"mickey" wrote:

Greetings:

I've written a UDF utilized in several cells , which if directed to
calculate essentially returns the value from another cell (each UDF is paired
with a different cell). The UDF can also be called by an event, which sets a
Static variable in the UDF then forces the target cell to calculate
(Target.Dirty). What was unexpected is that not just the target cell
calculates, virtually all cells that utilize the UDF re-calculate, regardless
of the fact that nothing has changed in their repective dependent cells.

Does anyone know what about this process is causing Excel to generate these
extraneous calculations?

Thanks.

To All:

I found the problem, and it had nothing to do with the UDF. I was so
focused on my own UDF, I forgot about the rest of the formula in each cell.
I made a mod and the "extraneous" calculations stopped.

Thanks anyway :-)



"mickey" wrote:

Greetings:

I've written a UDF utilized in several cells , which if directed to
calculate essentially returns the value from another cell (each UDF is paired
with a different cell). The UDF can also be called by an event, which sets a
Static variable in the UDF then forces the target cell to calculate
(Target.Dirty). What was unexpected is that not just the target cell
calculates, virtually all cells that utilize the UDF re-calculate, regardless
of the fact that nothing has changed in their repective dependent cells.

Does anyone know what about this process is causing Excel to generate these
extraneous calculations?

Thanks.