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

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

You mean name the range that gets the formula:

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

Then you could use:

=(mytotalcell + a3) * 12
(or some other expression)

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

--

Dave Peterson