Remove Circular Reference in Excel
In this tutorial, we explain how to remove circular reference in your excel model using an example of interest during construction i.e. IDC calculations.
The draft of VBA code used is as below. Please use the video to see the exact code as angular signs ( less than or great than )are not allowed in description:
Calculate
Range("Interest_paste").ClearContents
Do Until Range("Interest_check").Value (less than sign) 0.01
Range("Interest_paste").Value = Range("Interest_copy").Value
Calculate
Loop
End Sub
#msexcel #xceleratoe #VBA #macro #copypastemacro #circularreference #vbacoding #breakcircularreference #idc #remove #circular #excel #exceltips #exceltricks