circular reference when using a UDF

[Saira]

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

[Bernie Deitrick]

Saira,

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

HTH,
Bernie
MS Excel MVP


"Saira" <Saira@BayonetVentures.com> wrote in message news:e%23A05KtvFHA.724@TK2MSFTNGP14.phx.gbl...
> 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
>