Worksheet.CircularReference (Excel)

Returns a Range object that represents the range containing the first circular reference on the sheet, or returns Nothing if there's no circular reference on the sheet. The circular reference must be removed before calculation can proceed.


Dim rngCircularReference As Range
Set rngCircularReference = ActiveSheet.CircularReference