That did the trick...Thanks so much!

Bernie Deitrick wrote:
AHizon,

With Cells(Rows.Count, lCol).End(xlUp)
.Offset(1, 0).Formula = _
"=SUM(" & Range(Cells(2, lCol), .Cells(1, 1)).Address & ") - C2"
End With

HTH,
Bernie
MS Excel MVP

How do I hardcode a column in a formula? Currently I have the following
but
[quoted text clipped - 18 lines]
the
left of the cell with the formula. Any assistance would be appreciated.

--
Message posted via http://www.officekb.com