Sum dynamic range

[sfran]

Hello,

I'm trying to sum a range of cells starting from "B8" to a variable end row in the same column. I have tried various ways to try to accomplish this, but seems to keep failing. I would like to have the cell 2 rows below the end of this range to show the total. The code I am currently using is:

Sheets(Sheets.Count).Cells(featsummaryrow, 2) = Application.Sum(Range(Cells(8, 2), Cells(featsummaryrow - 2, 2)))

In other tests I have done, the Sheets(Sheets.Count).Cells(featsummaryrow, 2) portion is properly working (just had it equal to a number and it populates correctly). It seems my trouble is with the "summation" side of the equation. Have tried using .formula and other methods... i'm still doing something wrong.

Any insight is appreciated.

Thanks!

 

[Fluff]

How about

With Sheets(Sheets.Count)
   .Cells(featsummaryrow, 2) = Application.Sum(.Range(.Cells(8, 2), .Cells(featsummaryrow - 2, 2)))
End With

 

[sfran]

Thank you.. That did it!!

 

[Fluff]

You're welcome & thanks for the feedback.