I don't understand what you need a circular reference for, but will it
work if you enable iteration (ToolsOptionsCalculationIteration
checkbox)?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388501