Finding an error (circular reference) using VBA in Excel 1

[mal2ty]

How can VBA be used to detect a circular reference error in Excel?

I'm using VBA to completely automate a report that's been partially automated by someone else. The partial automation sometimes produces an Excel "circular reference error." My VBA code needs to check for circular reference errors and perform actions when a circular reference error is found.

Here is the pseudocode for what the VBA script needs to do:

While (intI <= Sheets.Count) {

If (Sheets(intI) has circular error) {
;// Do stuff
}

intI = intI + 1
}

Any help will be greatly appreciated.

 

[rsubras]

Hi,
I came across the same kind of error. but anyway since i was not doing any automation project i just debugged the program and using the help in Excel i trapped that circular error.......But if that could be achieved in VBA code I think that would be of great help......When you get such code can u plz put up in this forum

thank you

regards
R.Subramanian

 

[mal2ty]

R.Subramanian:

I will certainly post any solutions I come up with.

 

[rsubras]

hi,
thanx for that mal2ty.....and when i find one also i will post in here...

regards,
R.Subramanian

 

[Store300]

There is this...

MyRange = Worksheets([MySheet]).CircularReference.address Store300

Store300@ftnetwork.com