mandrivaal
New Member
- Joined
- Jan 19, 2016
- Messages
- 2
Greetings,
I'm trying to replace an unusual character ( ≠ ) in a sheet with vba. It's proving to be very difficult. Excel's default search and replace works fine ("<>") but I prefer automating these processes with vba. I have been very successful using the replace and instr functions for =, < , > , basically any char; However, this particular mathematical symbol is proving to be a pain. Google searches only provide the decimal key code of 8800 for this symbol. I just need the vba function that can handle this sort of symbol. debug print reveals this symbol as "?", so i'm assuming it doesn't know how to interpret it. Any input is appreciated.
Thanks!
I'm trying to replace an unusual character ( ≠ ) in a sheet with vba. It's proving to be very difficult. Excel's default search and replace works fine ("<>") but I prefer automating these processes with vba. I have been very successful using the replace and instr functions for =, < , > , basically any char; However, this particular mathematical symbol is proving to be a pain. Google searches only provide the decimal key code of 8800 for this symbol. I just need the vba function that can handle this sort of symbol. debug print reveals this symbol as "?", so i'm assuming it doesn't know how to interpret it. Any input is appreciated.
Thanks!