Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Saira
 
Posts: n/a
Default 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


  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate Circular Reference Brandt Excel Discussion (Misc queries) 1 August 3rd 05 11:43 PM
Highest Value / Circular Reference Help Josh M Excel Discussion (Misc queries) 1 May 23rd 05 07:33 PM
Highest Value / Circular Reference Help Josh M Excel Worksheet Functions 0 May 23rd 05 06:49 PM
Help solve a Circular Reference brupub Excel Worksheet Functions 6 February 14th 05 07:11 AM
Circular reference Pat Excel Discussion (Misc queries) 2 January 19th 05 05:52 AM


All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"