Hi

Look at this:

target.Offset(, 6).FormulaR1C1 = "=SUM(R[-1]C:R10C)"
ActiveWorkbook.Names.Add Name:="SumCell", RefersTo:="=Sheet1!" &
target.Offset(, 6).Address

Debug.Print Range("SumCell").Value

Regards,
Per


On 18 Sep., 22:56, Heather wrote:
Is there a way for me to name this so that I can use it later to total with
another section

* * target.Offset(, 6).FormulaR1C1 = "=SUM(R[-1]C:R10C)"

Thank you, Thank you