Sub test()
Dim maxrow&
maxrow = Cells(Rows.Count, 1).End(3).Row
Range("A1:A" & maxrow).Select
Cells(maxrow, 1).Activate
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[1]C"
End Sub
Sub test()
Dim maxrow&
maxrow = Cells(Rows.Count, 1).End(3).Row
Range("A1:A" & maxrow).Select
Cells(maxrow, 1).Activate
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[1]C"
End Sub