After your latest how can I not come back!

Seems like one of two possibilities or a combination is at issue.

1. In my Office97 bringing certain Windings (0034 & 0039 and others) into
Excel get converted to display as squares. Checking their codes all return
63 which is a question mark (not displayed as such). Something special with
picture fonts perhaps. But in my Office2000 all OK. (Might be difficult for
others to replicate the problem.)
or
2 Several characters are regarded as special for XL. I've already mentioned
the single quote but also a double quote and maybe a bracket (scissors,
candle & phone). If used in formulas could cause problems, maybe XL is
trying to pre-empt.

Try this:
In a backup of your source file, replace your characters by typing A B & C
in cap's respectively (3 different ok hands - right?). Repeat your drag copy
into XL. Individually select cells, press F2 edit and look in the edit box =
should see A, B, & C - right?

In the code change
vArr = Array(&H22, &H27, &H28) 'or (34, 39, 40)
to
vArr = Array(65, 66, 67)' codes for A, B & C

With the previous xlFormulas xlValues amendment, run the code. If this
works I don't know what to do as regards the other characters.

Regards,
Peter

"Larry Levinson" wrote in message
You, sir, to my undying gratitude, are my only correspondent to this
point.


"Peter T" <peter_t@discussions wrote:

You gave a clue with "drag copy". In Office97 I dragged cells containg
single Winding characters from a Word table into Excel. Some, but not all
character codes appear to have changed, odd! But doing same in Office2000
and everything seems normal, and my code works as expected.

I might have been a bit hasty about saying the Wingdings font was not
related. I'll try and have another look tomorrow, unless (hopefully!)
someone else has sorted you out.

Regards,
Peter

"Larry Levinson" wrote in message
.. .
right, i am sure the code would work on the characters created that
way. My problem is that I need to be able to work on a group of
characters from another source that I copy (click and drag) and paste
into Excel.

Its from that list of 20 characters that I want to be able to count
the number of scissors, the number of candles, and the rows in which
the candles appear. Unfortunately, I do not have the luxury of being
able to create the characters myself; I need to read it from the list
I generate from my source.

While they APPEAR to be scissors, phones and candles, apparently there
is something else in the cell that we can't tease out. If you really
want to see it, send me your email address and I will send you a copy
of my Excel sheet.



"Peter T" <peter_t@discussions wrote:

Try the simple way, enter your characters as:
a double quote ", an apostrophe (but do twice), and an open bracket
"(".
or alt 0034, Alt 0039, Alt 0040

Select cells containing the above and try my code again. The Font
Wingdings
or whatever is not relevant (except the candle / apostrophe issue).

Regards,
Peter



"Larry Levinson" wrote in message
.. .
thanks for your help, but I think I am going to have to do this
another way BECAUSE ... i tried your syntax on a column of wingding
characters that I created with ALT-61474 etc ... and it came up with
one for the candle, which is correct. ran the same text on my column
of 20 that I copied/pasted from another source and then set the font
for that column to wingdings and it failed to find anything.
THEREFORE, I believe that it only LOOKS like those symbols, but its
either really something else or within some kind of container that
we
don't seem to be able to pierce.


snip<


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)