Re: Edit-->Find special characters

In the end I want to do the find with VBA code. Sorry I forgot to mention
that. Any suggestions on how to search for ANSI or ASCII using VBA's
Selection.Find(...)?



"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:uUWbW0c1FHA.2792@xxxxxxxxxxxxxxxxxxxxxxx
> hold the alt key and use the number pad to key in the ascii code for what
> you're looking for in the find box
>
> --
>
>
> Gary
>
>
> "Dave B" <davidbarbetta@xxxxxxxxxxx> wrote in message
> news:OaLJrqc1FHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
> > With Excel 2000's Find function, I thought you could use a ^ symbol to
> > find
> > special characters using ANSI codes, but when I enter ^84 or ^084 (the
> > ANSI
> > code for capital T), it does not find any matches, even though there are
> > many T's in the work***. I'm searching "By Rows" and looking in
> > "Formulas", A1 is the only active cell. What am I doing wrong? Thanks.
> >
> > (P.S. I'm looking for other characters that are not on the keyboard like
> > "T"
> > is, too.)
> >
> >
>
>


.

Loading