I run a weekly report each Friday. I was on vacation last week. When I try to run the macro, I get the error. This has worked for years, but now crashed for some reason.
During my vacation, I was upgarded to MS Office 2007, could that be the issue?
During my vacation, I was upgarded to MS Office 2007, could that be the issue?
Code:
With PolicyD.Sheets(1)
.Columns("D").Insert Shift:=xlToRight
.Columns("D").NumberFormat = "General"
.Range("D1") = "Prev Pol Number"
.Columns("D").AutoFit
.Activate
[Red].Cells(2, 4).Resize(rCount - 1, 1).Formula = "OMIT FORMULA"[/Red]
.Range(.Cells(2, 4), .Cells(rCount - 1, 4)).Value = .Range(.Cells(2, 4), .Cells(rCount - 1, 4)).Value
End With