I need to fill in blank spaces in column C in a spreadsheet. The loop should start from the bottom of column C and step up. If the next cell up is blank, I need to copy and paste from the cell below. The problem I'm having is my code selects all the blank cells and copies from the cell below. I just want this copying to happen in column C.
What am I missing?
Dim LastRow As Long
Dim i As Long
Application.ScreenUpdating = False
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = LastRow To 1 Step -1
Selection.FormulaR1C1 = "=R[+1]C"
Application.ScreenUpdating = True