View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Ponzelli[_3_] Paul Ponzelli[_3_] is offline
external usenet poster
 
Posts: 3
Default selecting an AutoFilter value in code

Is there a way to set the value of an AutoFilter drop box in code?

Assume you've already run the following code to show all records:

If Sheets("Address").FilterMode Then
Sheets("Address").ShowAllData
End If

Is there a line of code you can run to filter the records by a particular
value in one of the autofilter drop boxes? Let's say, for example, that one
of the values in the AutoFilter drop box in cell C1 is "Texas." Is there a
way to set that value in the AutoFilter to "Texas"?

Thanks in advance,

Paul