Results 1 to 21 of 21

Advanced filter error message

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Advanced filter error message

    Hello everybody
    I am trying to apply advanced filter but I got an error .. missing field ..
    Sub FilterData()
        Dim LastRow As Long
        LastRow = Sheets("Sheet2").Cells(Rows.Count, 4).End(xlUp).Row
        
        Sheets("Sheet3").Range("G5:N1000").ClearContents
        Sheets("Sheet2").Range("D4:L" & LastRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("Sheet3").Range("P1:S2"), CopyToRange:=Sheets("Sheet3").Range("G5:N5"), Unique:=True
    End Sub
    How can I filter data without using this method as this method depends on criteria table which is P1:S2 in sheet3?

    Thanks for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Advanced Filter Error
    By csh8428 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 05:56 PM
  2. Advanced Filter Error
    By Floyd Bates in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 02:20 PM
  3. Advanced Filter - error message
    By Mifty in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-25-2006, 02:10 PM
  4. [SOLVED] Advanced Filter Error
    By Claret in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2006, 11:55 AM
  5. advanced filter error 1004
    By Tove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1