Re: Edit-->Find special characters

With Columns(2)

Set fndRange = .Find(what:=Chr(84), LookIn:=xlValues)
End With
If fndRange Is Nothing Then
MsgBox "Not found"
Else
fndRange.Interior.ColorIndex = 37
End If
End Sub

--


Gary


"Dave B" <davidbarbetta@xxxxxxxxxxx> wrote in message
news:eRb%23FDd1FHA.460@xxxxxxxxxxxxxxxxxxxxxxx
> 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.)
>> >
>> >
>>
>>
>
>


.