Circular: 02 in status bar

[duugg]

Hello all,

I got this message

Please Login or Register  to view this content.

in the status bar after running a macro. Does this mean that the code didn't run right?

Note that I didn't get an actual message box popping up saying that there was an error.

Thanks

[Phil_V]

Hi Duugg,

It means that a circular reference has been created involving cell O2.

For example if cell N2=O2+1 and O2=P2+1 and P2=N2+1 you would have a circular reference as the cell, (in this case each cell), refers back to itself.
To resolve it, from the 'View' menu of Excel select 'Toolbars' and then 'Circular Reference'.

Select Cell O2, then on the circular reference toolbar click the button that has the eraser and the arrows. You can then click either or both of the other buttons that have arrows on to determine which cells O2 refers TO, and also which cells refer to O2.
Once you can see how / why the circular reference has been created you will need to look at your macro to see what caused it, (presuming you didn't intend for it to happen )

[duugg]

I did indeed figure it out. I had it doing calcuations on a column that no longer existed.

Thanks Phil!