Hello all,
I got this message
in the status bar after running a macro. Does this mean that the code didn't run right?Circular: 02
Note that I didn't get an actual message box popping up saying that there was an error.
Thanks
Hello all,
I got this message
in the status bar after running a macro. Does this mean that the code didn't run right?Circular: 02
Note that I didn't get an actual message box popping up saying that there was an error.
Thanks
Last edited by duugg; 08-06-2009 at 12:20 AM.
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 )
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
I did indeed figure it out. I had it doing calcuations on a column that no longer existed.
Thanks Phil!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks