Arthur Fuller
fuller.artful at gmail.com
Thu Nov 1 08:51:56 CDT 2007
I'm having trouble with Excel's find method. I know that the target data is
there, but the Find method keeps returning Nothing and I can't discern my
error. Here is the code:
<code>
Dim intr As Integer
Dim MatchedCell As Range
With CntrySheet.Range("B1:B50")
Set MatchedCell = Cells.Find(What:="Asset Mix of
Underlying Funds:", _
After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)
If Not MatchedCell Is Nothing Then
intr = MatchedCell.Row + 2
Else
' a band-aid until I figure out what's wrong with the search
intr = 18
End If
End With
</code>
I read somewhere that Excel remembers your last Find settings, which is why
I specify them all, but it still doesn't work. I can see the target string,
it's right there on row 18, but I cannot guarantee that it will always be on
row 18. I have also substituted "walk the column" code for the above,
comparing each entry to the target string -- which works, but I would like
to know why my Find code is failing.
TIA,
Arthur