I am working on a program which sums a collumn; however, the column is created by a loop and therefore the last cell is a variable. How do I enter a variable in the formula. I tried several variations of this:
a = Range("A1").Formula = "=sum(Range(("b" & 3), ("b" & currow)))
However the formula is not recoginized as a formula and will not sum the range.