Hi,

I made autofilter by tow fields and I get 131 filtered rows.
Rows 2058-2102 and 3758-3842.
I want to over on all rows and get data for it.
When I do it I success to over only on the 45 first sequential rows.

the start of the code is:
With filterRng
.AutoFilter Field:=37, Criteria1:=appName
.AutoFilter Field:=38, Criteria1:=activityType

If .Columns(1).Cells.SpecialCells(xlCellTypeVisible) _
.Cells.Count = 1 Then
'No filter row
'MsgBox "nothing visible in the filter!"
Exit Sub
End If

Set myRng = .Resize(.Rows.Count - 1, .Columns.Count) _
.Offset(1, 0).Cells.SpecialCells(xlCellTypeVisible)
End With

myRng iclude only 45 lines (2058-2102 rows). Why?

How can I move over all the rows?
Thanks,
Shlomit