Q about Unicode and the ChrW function in VBA

[Erik O]

Hi ,

I understand from the documentation that the ChrW function supports a value up to 65535. So this code works fine:

Range("C2") = ChrW(9000)

And this one gives an error:

Range("C2") = ChrW(128247)

So, how do I insert a Unicode number higher than the limit of the ChrW function - if possible?

Kind regards
Erik

 

[Fluff]

Try

Range("C2") = WorksheetFunction.Unichar(128247)

 

[Erik O]

Try

Range("C2") = WorksheetFunction.Unichar(128247)

That worked! Thank you so much

 

[Fluff]

Glad to help & thanks for the feedback