Advanced Filter Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how to program a button on my spreadsheet to do an
advanced filter? When I try to program a macro, the menu to select advanced
filter is gray'd out.

My list is A4:L17814 and my criteria is A1:L2. Any help would be appreciated.
 
Is your worksheet protected? (Tools|Protection|unprotect sheet)

Do you have any grouped sheets? (right click on any and choose Ungroup sheets)

Is the workbook protected? (Tools|Protection|unprotect workbook)

But I recorded this:

Range("A4:L17814").AdvancedFilter Action:=xlFilterInPlace, _
CriteriaRange:=Range("A1:L2"), Unique:=False
 
Back
Top