How do you work with high character numbers?

[Mel]

I've worked with characters such as Chr$(187) and such but now I have
to insert or search/replace a character that has a much higher number
in the mapping, such as Chr$(9674), which is a diamond looking symbol
("lozenge"). Excel errors with such numbers but runs fine with a lower
number.

How can I do a search for Chr$(8482) and replace with Chr$(9674)?

(These character numbers came from seeing them in an insert symbol
macro recording in Word. Character Map shows them as U+2122 and U+25CA
respectively.)

Thanks a bunch,
Melina

 

[jason]

I've worked with characters such as Chr$(187) and such but now I have
to insert or search/replace a character that has a much higher number
in the mapping, such as Chr$(9674), which is a diamond looking symbol
("lozenge"). Excel errors with such numbers but runs fine with a lower
number.

How can I do a search for Chr$(8482) and replace with Chr$(9674)?

(These character numbers came from seeing them in an insert symbol
macro recording in Word. Character Map shows them as U+2122 and U+25CA
respectively.)

Thanks a bunch,
Melina

why wouldn't Replace(Yr_Var, cstr(Chr$(8482)), cstr(Chr$(9674))) work?

 

[Mel]

I don't know why it won't work... I can't even get it to compile. Is
this what you were suggesting?

Sub ReplaceChrs()
Replace(range("a1").value, cstr(Chr$(8482)), cstr(Chr$(9674)))
End Sub

I've used other routines and using lower numbers they worked, but
these larger numbers blow it apart and so I'm thinking they must need
something else.

Any insight on this from anyone?

Thanks,
Melina

 

[Mel]

I was told to use ChrW$ instead of Chr$ and it worked. Thanks.

-Melina