Autofilter: Page Fields: select if only one entry

[kkatzer]

Hello,

If I have some page fields which each contain only one data value, how can I programmatically select the single data value? The "All" entry shows by default and I would like to save the user a bit of clicking.

Thanks for your help... Kim

[derekbrown]

Hi,

Give this a try:

Range("your cell in here").AutoFilter Field:=1, Criteria1:="your date in here"

Cheers

Derek