VBA - Using a named range in R1C1 reference

[spencerp237]

Dim lastRow As Integer
Dim ws1 As Worksheet

Set ws1 = Sheets("PayoutsTest")
lastRow = ws1.Cells(Rows.count, 1).End(xlUp).Row


'Sum Columns
With ws1.Range("B2")
    .FormulaR1C1 = "=SUM(R[1]C:R&lastRow&C)"
End With

Above is the relevant part of my code. The lastRow could be changing so I want to used a named range. Is there a way to insert that into a R1C1 reference like I tried doing above?

Thanks for any help.

 

[Norie]

Do you want to use a named range or do you just want to incorporate lastRow into the code?

If it's the latter try this.

With ws1.Range("B2")
    .FormulaR1C1 = "=SUM(R[1]C:R" & lastRow &"C)"
End With

If it's the former can you explain further?

 

[spencerp237]

That is exactly what I needed! I had tried it using the &'s, but not with the parentheses. Thanks a lot!