View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default AutoFilter Custom Dialog

Sub Tester2()
Application.ExecuteExcel4Macro "FILTER?(1,""*A*"")"
End Sub

the 1 pertains to which column. the ""*A**"" would produce contains A,
alter to suit your needs. The autofilter dropdowns should already be
visible on the active sheet.

--
Regards,
Tom Ogilvy

"AlexJ" wrote in message
...
All,
Is it possilbe to access the "Custom" filter Dialog box
that is available when the user manually selects the drop-
down in an autofiltered field header.

I have review the list of built-in dialogs and could not
locate it.

TIA,
AlexJ