PDA

View Full Version : Auto Filter Again



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"

malik641
12-20-2005, 09:01 AM
Hey Gibbo, could you post a workbook? Your code works fine for me :dunno Maybe I'm not doing the same thing you are????

gibbo1715
12-20-2005, 09:09 AM
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

malik641
12-20-2005, 09:11 AM
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?