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

On Nov 20, 1:45*pm, Mel wrote:
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?

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


On Nov 20, 2:04 pm, jason wrote:
why wouldn't Replace(Yr_Var, cstr(Chr$(8482)), cstr(Chr$(9674))) work?


On Nov 20, 1:45*pm, Mel wrote:

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

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

-Melina

On Nov 20, 2:27*pm, Mel wrote:
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

On Nov 20, 2:04 pm, jason wrote:

why wouldn't Replace(Yr_Var, cstr(Chr$(8482)), cstr(Chr$(9674))) work?
On Nov 20, 1:45*pm, Mel wrote:

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