Getting #REF result from FormulaR1C1 = "=R[-1]C"

[SAMCRO2014]

I am trying to copy a value in a cell to the blank cells below. I have the following:

Dim LastRow As Long
LastRow = PLSR.Cells(Rows.Count, 2).End(xlUp).Row

Copy Employee number in Column A to blank cells below
With Range("A1:A" & LastRow)
.SpecialCells(xlBlanks).FormulaR1C1 = "=R[-1]C"
.Value = .Value
End With

I keep getting a value of #REF . I can't see why. What I am missing?

 

[Fluff]

Is A1 blank?

 

[SAMCRO2014]

No. It contains a value of "0". Does it need to be blank?

 

[SAMCRO2014]

With Range("A1:A" & LastRow) should be With Range("A2:A" & LastRow). Thank you for pointing me in the right direction again, Fluff!!!!

 

[Fluff]

Glad you sorted it & thanks for the feedback