Advanced Filter Question
 

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

Advanced Filter Question
 

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





Don wrote:

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

--

Dave Peterson