circular reference when using a UDF
 

Hi all
I have a UDF that seems to be creating a circual reference, however the code
seems fine. In addition the cell returns the correct value when I turn
iterations on. However, I would like to resolve this problem without turning
iterations on.
The code is being called from about 600 cells.

Has anyone come across similar behaviour? Can anyone help?

Regards
Saira

circular reference when using a UDF
 

Saira,

Post your code, and show how you are calling the UDF from the worksheet.

HTH,
Bernie
MS Excel MVP


"Saira" wrote in message ...
Hi all
I have a UDF that seems to be creating a circual reference, however the code seems fine. In
addition the cell returns the correct value when I turn iterations on. However, I would like to
resolve this problem without turning iterations on.
The code is being called from about 600 cells.

Has anyone come across similar behaviour? Can anyone help?

Regards
Saira