Problem in VBA with function FIND(...

[Decaplan]

Bonjour,

I've exactly done this in a new workbook:

Sub Essai()
Dim cellule
Set cellule = Worksheets("Feuil1").Range("A:A").Find(what:="Toto",
LookIn:=xlValues)
MsgBox cellule.Value
End Sub

Programme finds the cell when it is visible and don't find when it is hidden
or when it is grouped.
If somebody has few minuts to see my problem I can send him the workbook.

Thanks
Decaplan

 

[Dave Peterson]

I used xl2002.

If I hid the row manually, Edit|Find found the cell.
If I hid it using data|filter|autofilter, then edit|find didn't find the cell.

If I did a Data|group and had some rows hidden, then edit|Find found it ok.

That's the way excel works. Unhide the hidden rows before you do the find.