find in excel with sheet with grouping

[robcarr]

Hi,

I am using this coding to find a date within a column

FindString = rdate
    If Trim(FindString) <> "" Then
        With Sheets("Bose - Daily").Range("b:b")
            Set rng = .Find(What:=FindString, _
                            After:=.Cells(.Cells.Count), _
                            LookIn:=xlValues, _
                            LookAt:=xlWhole, _
                            SearchOrder:=xlByRows, _
                            SearchDirection:=xlNext, _
                            MatchCase:=False)
            If Not rng Is Nothing Then
                Application.Goto rng, True
            Else
                MsgBox "Nothing found"
            End If

however if the date i am looking for is hidden within a group (group is set on level 1 - hiding data only showing weekly sumamry), it will not find the value, is there a way to get this to find the date within all groups.

thanks

Hope this is of use, Rob.