How to Reference Special Characters Using Excel vba
vba
Solution
User `ChrW()` instead of `Chr()` function to reference Unicode characters:
`ChrW(23383)` will produce `字`.
`Chr(23383)` will throw an exception.
Problem
I have several special characters in an excel spreadsheet. How do I reference them in Excel VBA? The characters I need are not in the standard 255 ASCII codes. I was thinking perhaps `Chr(code)` would work, but I'm not able to find the codes for the characters I need to test this.