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
|