A variable SUM formula in excel

[bbuk9999]

Hi all, does anyone know how to provide a variable SUM formula. For example: SUM(A1:Variable), This variable can be any range like SUM(A1:K10) or SUM(A1:N20). Thanks in advance.

[Paul_Hossler]

If this is the same question that you asked here:

http://www.vbaexpress.com/forum/showthread.php?55993-How-to-generate-Sum-formula-in-excel

the answers would probably be the same unless you can tell us what was wrong with them

[bbuk9999]

thanks Paul, The variable range depends on a variable that can be inserted using VBA code.

[Paul_Hossler]

Option Explicit

Sub test()
Dim r1 As Range, r2 As Range
Set r1 = Range("A1")
Set r2 = Range("E10")

MsgBox Application.WorksheetFunction.Sum(Range(r1, r2))

End Sub