gibbo1715
12-20-2005, 08:46 AM
Can anyone tell me why this starts my auto filter at row 1 and not row 8 and therefor doesnt filter correctly?
Cheers
Gibbo
Dim iLastRow As Long
iLastRow = Cells(Rows.Count, "B").End(xlUp).Row
Workbooks("Outstanding").Sheets("Data").Range("B8:L" & iLastRow).AutoFilter _
Field:=3, Criteria1:="=Hello"
Cheers
Gibbo
Dim iLastRow As Long
iLastRow = Cells(Rows.Count, "B").End(xlUp).Row
Workbooks("Outstanding").Sheets("Data").Range("B8:L" & iLastRow).AutoFilter _
Field:=3, Criteria1:="=Hello"