Edit--Find special characters
 

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 worksheet. 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.)

Edit--Find special characters
 

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" wrote in message
...
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 worksheet. 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.)

Edit--Find special characters
 

Couldn't you just do Edit|Find, type in T and make sure "match case" is checked
(under the Options button if you don't see it).

Maybe you had "match entire cell contents" checked that caused the trouble.

Or maybe something wrong in the LookIn box (or within box).

===
There are some characters that can't be used in that dialog. Carriage return
(x013) has never worked for me.



Dave B wrote:

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 worksheet. 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.)

--

Dave Peterson

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
...
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" wrote in message
...
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 worksheet. 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.)

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" wrote in message
...
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
...
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" wrote in message
...
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 worksheet. 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.)

Edit--Find special characters
 

Something like:

Option Explicit
Sub testme()
Dim FoundCell As Range

Set FoundCell = ActiveSheet.Cells.Find(What:=Chr(84), _
LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=True)

If FoundCell Is Nothing Then
MsgBox "Not found"
Else
FoundCell.Activate
End If
End Sub



Dave B wrote:

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
...
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" wrote in message
...
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 worksheet. 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.)





--

Dave Peterson