Hello,
I am trying to remove non printed in characters in a range of cell (D15 to Q114) using the CLEAN function but I'm having trouble with the syntax. Can anyone help
Thanks
Colin
Hello,
I am trying to remove non printed in characters in a range of cell (D15 to Q114) using the CLEAN function but I'm having trouble with the syntax. Can anyone help
Thanks
Colin
Hi Colin,
try this
Sub test() With Range("D15:Q114") .Value = Application.Clean(.Value) End With End Sub
Sorted. Thanks for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks