Hi,

change your if statement to:

If Not .HasFormula And .Value <> "" Then