jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
I recently added the one-line in RED below; Since then I'm getting the RT 1004 error WITHOUT REASON!! - I've been trying to fix it for an hour, without success. Any thoughts?
Rich (BB code):
With Worksheets("FinalReport")
NLr = .Range("G" & Rows.Count).End(xlUp).Row
.Range("F6:F" & NLr).Value = Range("F6:F" & NLr).Value
.Range("M6:M" & NLr).Formula = "=IF(ISERROR(I6+J6-K6),"""",I6+J6-K6)"
.Range("N6:N" & NLr).Formula = "=IF(ISERROR((H6*0.9)-K6),"""",(H6*0.9)-K6"
End With