On Apr 8, 8:22*am, Dave Peterson wrote:
You may want to try Stephen Bullen's utility:http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip





RJQMAN wrote:

When my program opens, I get a notice that there is a circular
reference. *My program automatically goes to a 'welcome sheet' when
opening, and when I cancel the message, the welcome sheet appears, and
I cannot figure out how to find that circular reference. The circular
reference toolbar appears, but there is no cell displayed.

*It is a very large program, and seems to work well in general, but
there are a lot of options and a lot of formulas and I do not know how
to find the cell that is causing this error message. *I do not know
what page the reference is on, or if it is in a user form, or where to
look.

Every solution I have found recommended requires that I start with a
problem cell. *I do not know how to find that problem cell or cells to
start with.

Can anyone tell me how to find this without manually going through
thousands of cells trying to find it? *I would really appreciate some
help.

--

Dave Peterson- Hide quoted text -

- Show quoted text -

I have tried that, but it seems to require that I know what cell to
start with.