I looked at: Sub Check_For_Inactive_Documents()

Why don't you use 2 ( red & magenta) simple conditional formatting rules in range I2:Z2000 in sheet 'cross referencing docs' ?
You don't need any VBA for this;
You won't even notice the calculation time.

To count the inactive lines: use countif instead of VBA.