Hi guys,
I have this code that, for column X, fills all blanks with the value above. Range is same as W.
For column AH, I need to fill all blanks with the value from U, which is 13 columns to the left. (Example: AH4 = U4 ; AH20 = U20). Same range. Can you help me?
Cheers
I have this code that, for column X, fills all blanks with the value above. Range is same as W.
For column AH, I need to fill all blanks with the value from U, which is 13 columns to the left. (Example: AH4 = U4 ; AH20 = U20). Same range. Can you help me?
Cheers
VBA Code:
Sub copyToBlanks1()
With Range("X2:X" & Range("W" & Rows.Count).End(xlUp).Row)
.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
.Value = .Value
End With
End Sub