Using 2003

Would like, within a VBA procedure, to make Excel Autofilter choices from
selected fields.

I prefer not to enter my choices via an InputBox or MsgBox as the choices
are typically 35+ characters.

In short,

Sub Test
With ManyWorkSheets

.... series of (non-Pivot Table sheet) w/s processing

.... Select "Pivot Table" worksheet
.... cause two-field's dropdown boxes to activate (one at a
time)
.... continue series of (non-Pivot Table sheet) procedures.

Next ManyWorkSheets

End With

End Sub

Any thoughts? (keep it clean!)

Thanks Dennis