problem with Find()

[alienscript]

Hi,

The code below only select the first found cell that contain any combination of "a", like "add","dad",etc.

If I want to find in row 11 after A11, of only the first found cell that contains only an upper case "A". How should I do this?

I'm using XL 2003. Thanks a lot.



Rows("11:11").Cells.Find(What:="A", After:=[A11]).Select

[mikerickson]

VBA Help will explain the other arguments of .Find

With Rows(11)
MsgBox .Find(What:="A", After:=.Cells(1, 1), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=True).Address
End With