Sum -1

[kenpcli]

How do I get this to add but disregard the first cell:

Q.Formula = "=SUM(" & rAbove.Address & ")"

 

[Scott Huish]

Q.Formula = "=SUM(" & rAbove.Offset(1).Resize(rAbove.Rows.Count - 1).Address & ")"

You didn't say how you defined rAbove. It may be easier to set the range how you want it there.

 

[kenpcli]

Thank you, worked great.