Auto Filter Again

Can anyone tell me why this starts my auto filter at row 1 and not row 8 and therefor doesnt filter correctly?

Cheers

Gibbo

[VBA] 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" [/VBA]

Hey Gibbo, could you post a workbook? Your code works fine for me :dunno Maybe I'm not doing the same thing you are????

Thanks for the reply Joseph

I Just realised im being an idiot as I already had the autofilter turned on on row 1, turned it off and works fine!!!!

Must be time for me to go home before i go nuts

Cheers

Gibbo

Quote:

---

Originally Posted by gibbo1715

I Just realised im being an idiot

---

:giggle That's funny.

Go home???? My day JUST STARTED!! That's not fair! :) What is it like 6:11PM over there?