For Each cl In Range("G7", Range("G" & Rows.Count).End(xlUp))
If cl.Value <> Null Then
cl.Value = "ABCD " & Range("F")
End If
Next cl
Hello All,
I'm attempting to add the letters ABCD to each cell in column G, starting at G7, with the number in column F
Example:
F7=2567, then G7 would =...