Thread: Opening Built-In Custom AutoFilter Dialog Box Programmatically
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Aijik Aijik is offline
external usenet poster
  
Posts: 1
Default Opening Built-In Custom AutoFilter Dialog Box Programmatically

Try this

Application.ExecuteExcel4Macro "FILTER?(1)"

where 1 is the number of column

or for a predefined value:

Application.ExecuteExcel4Macro "FILTER?(1, ""sometext"")"


--
Aijik
------------------------------------------------------------------------
Aijik's Profile: http://www.excelforum.com/member.php...o&userid=34691
View this thread: http://www.excelforum.com/showthread...hreadid=542394

Reply With QuoteReply With Quote