Hi,
I can get rid of Char 160 using SUBSTITUTE(A1,CHAR(160),"") in Excel, but would like todo this in VBA. So I have the below code but its doesn't seem to work.
For Each A In Range("B15:B" & Range("B65536").End(xlUp).row)
ID = A.Value
ID = Application.WorksheetFunction.Substitute(ID, Chr(160), "")
A.Value = ID
Next A
Please can anybody assist.
Thanks
I can get rid of Char 160 using SUBSTITUTE(A1,CHAR(160),"") in Excel, but would like todo this in VBA. So I have the below code but its doesn't seem to work.
For Each A In Range("B15:B" & Range("B65536").End(xlUp).row)
ID = A.Value
ID = Application.WorksheetFunction.Substitute(ID, Chr(160), "")
A.Value = ID
Next A
Please can anybody assist.
Thanks