VBA Macro Sum Variable Range

Question

I need to add up the total for column L, I know the first and last rows:

lRow = Cells(Rows.Count, 2).End(xlUp).Row
fRow = Cells(lRow, "B").Value

So how do I use lRow and fRow in my SUM?

Vityata · Accepted Answer · 2016-09-28 10:46:03Z

3

activecell.Formula = "=SUM(L" & lrow & ":L" & frow & ")"

Edit - Added:

Sub Assign
  dim dbl_assign as long

  lRow = Cells(Rows.Count, 2).End(xlUp).Row
  fRow = Cells(lRow, "B").Value

  activecell.Formula = "=SUM(L" & lrow & ":L" & frow & ")"

  dbl_assign = activecell.value

end sub

edited Sep 28, 2016 at 10:46

answered Sep 28, 2016 at 10:34

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

davidjwest Over a year ago

Thanks - how would I use that to assign the value retrieved by the formula to a variable in the VBA?

Collectives™ on Stack Overflow

VBA Macro Sum Variable Range

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related