His code was correct. I was referring to his description of how to do it manually, without code.

On Mon, 04 Aug 2003 19:50:27 -0500, Dave Peterson wrote:

Tom Ogilvy wrote:

RE doing it manually: I think you omitted converting the formulas in F:I to
their values. You need to do this before deleting rows.

Think he did that right he

With .Range("F1:J" & LastRow)
.Value = .Value
End With

--
Regards,
Tom Ogilvy