Macro for search and replace dash - unicode character not recognised

Hi, I’m a bit new to VBA coding but I’m having trouble with a macro I've recorded. I’m trying to create a macro that search for a certain character (−) that seems to have a unicode character "2212" (Im inserting the sign in Word and by using Alt + X it returns the value "2212"). I want to replace it with an minus sign / dash so excel wont treat the data as text (if i do the same in Word it returns the value "002D").

Please Login or Register  to view this content.

I don’t know it its correct to ad a "&H" but that’s the only way I’ve found to make the VB editor accept my formula. It also removes the two zeros for some reason. Anyone that knows what I’m doing wrong? I’m very thankful for all help that you can give!

Try change What:= to ChrW(8722) and Replacement:= to "-" and see if it works...

Thx jindon for your reply, it sort of works! For some reason I tried your soloution without the "ActiveWorkbook.RefreshAll" that reloads data that is linked to a webpage, and then it replace all incrorrect characters that i want. But with the refresh in the macro, it doesn't work? It seems like its done in the wrong order or something?

If I'm right, you will need to replace each time after your refresh macro...

Anyway you can get character code by AscW function...