Gang -

In set range r this code works:

With r
  .formula = .value
End With

This doesn't:

With r
  .formula = vba.replace(.value,chr(160),chr(32),1)
End With

What am I missing?

Thanks in advance.
...best, Hash