circular reference when using a UDF

  • Thread starter Thread starter Saira
  • Start date Start date
S

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
 
Saira,

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

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
circular reference - iteration 5
Recalculating in a circular reference 3
Excel Iterative calculations 3
Creating a UDF to convert ADDRESS function output as a reference 3
UDF's & puzzling recalculation behavior 3
UDF - not always calculated 9
circular reference calculation error 2

Back
Top