[RESOLVED]Advanced Filter

[Mitch_s_s]

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?

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

[Siddharth Rout]

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...

[Mitch_s_s]

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?

[Siddharth Rout]

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!!!!!!!!

[Mitch_s_s]

haha!

that bad eh?

[Siddharth Rout]

yeah