Disabling Excel Prompting when it detects a circular reference
 

Controlling the iterations, maxiterations and maxchange properties might
help. See Excel help. Use Tools-Options-Calculations to set or use VBA
Application.Iterations = True

Cheers
Nigel

"ECE" wrote in message
...
Hi,

Does anyone know how to disable the MS Excel prompting of circular
references ? Thanks.

--
Regards,
Adrian