I am trying to create a column "H" that will display the values in column F unless F is empty. In such a case, the value from column E will be entered into column H, however I am new to using vba and am not sure how to fix this macro as it continues to fail on the first line "If Range("Fi").Value = Empty Then".
Any advice would be greatly appreciated!
Sub AdditionalColumn()
Dim i As Integer
i = 2
Do:
If Range("Fi").Value = Empty Then
Range("Hi").Value = Range("Ei").Value
Else: Range("Hi").Value = Range("Fi").Value
End If
i = i + 1
Loop
End Sub
Any advice would be greatly appreciated!
Sub AdditionalColumn()
Dim i As Integer
i = 2
Do:
If Range("Fi").Value = Empty Then
Range("Hi").Value = Range("Ei").Value
Else: Range("Hi").Value = Range("Fi").Value
End If
i = i + 1
Loop
End Sub