Hi All, below code is working on Active cell. however i want this code to run on entire worksheet.
Sub MyTracer()Dim rngTrace As Range
Set rngTrace = Range("xx" & Rows.Count)
Dim CheckPrecedents As Variant
On Error Resume Next
CheckPrecedents = ActiveCell.Precedents
If Err Then Exit Sub...