[RESOLVED]Advanced Filter

the attached code does not appear to be working,
i enter my criteria, say into F2
run the attached code, but no filter is applied
is there anything wrong this code?

VB Code:

Sub AdvFilter()
 
    Range("A9").Select
    Range("A9:K103").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
        Range("A1:K2"), Unique:=False
        
End Sub

I tried it...

It is working for me...

can you upload the file?

or if you prefer type "Filter by using advanced criteria" in MS Excel Help. It has a ready example on how to go about it...

Hope it helps...

hmm not sure why it wasnt workin for me

i changed my data table round
an it worked

nice one anyway mate :)

ps how did you get on with your attendance sheet?

Quote:

---

ps how did you get on with your attendance sheet?

---

What attendance sheet? ;)

I don't remember and I don't want to remember any attendance sheet!!!!!!!! :D

haha!

that bad eh?

yeah :D