Name error

[Gregfox]

Hi All,
The following code gives a name error in cell I2. Anyone know how I could fix it?

StartYear2018 is a named cell. Working with excel 2007 on a PC.​

 Dim StartYear As Double
     StartYear = Range("StartYear2018")
     
 Range("I2").Select
 ActiveCell.FormulaR1C1 = "=+SUM(R[1]C: StartYear)"

Thanks.

 

[Gregfox]

I tried that and at last it worked!
Many thanks again.

 

[ZVI]

It's nice to know you have got it worked!