Results 1 to 6 of 6

Thread: [RESOLVED]Advanced Filter

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2007
    Location
    England
    Posts
    234

    Resolved [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:
    1. Sub AdvFilter()
    2.  
    3.     Range("A9").Select
    4.     Range("A9:K103").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
    5.         Range("A1:K2"), Unique:=False
    6.        
    7. End Sub
    Last edited by Mitch_s_s; Feb 17th, 2007 at 05:26 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width