One way:

With Range("C2")
If IsEmpty(.Value) Then .Value = .Offset(0, -1).Value
End With

In article ,
"Gerry" wrote:

If C2 is blank then put value of B2 into C2 otherwise
leave C2 as it is. All data type are the same. Can anyone
help me with this please.