Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Criteria
Hi guys
Using AutoFilter on a range, for a particular column, there are 2 or more possible values. I wish to always filter by the second value. How do I do this in code? Thanks in advance Paul Martin Melbourne, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Criteria
Not understanding Paul.
I would think that you just filter by that value, but as that is too obvious, I guess there is more to your question. Where does this 'second value' come from? -- __________________________________ HTH Bob "Paul Martin" wrote in message ... Hi guys Using AutoFilter on a range, for a particular column, there are 2 or more possible values. I wish to always filter by the second value. How do I do this in code? Thanks in advance Paul Martin Melbourne, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Criteria
Bob
I mean that for a given column/filter, the dropdown list includes generally 2 (but sometimes more) values. Whatever the 2nd value is in the dropdown, that's what I'm after. The Excel Object Model doesn't seem to make the items in this list available to the same degree as other objects and I'm trying to find another way around this. Paul -- Paul Martin Melbourne, Australia "Bob Phillips" wrote: Not understanding Paul. I would think that you just filter by that value, but as that is too obvious, I guess there is more to your question. Where does this 'second value' come from? -- __________________________________ HTH Bob "Paul Martin" wrote in message ... Hi guys Using AutoFilter on a range, for a particular column, there are 2 or more possible values. I wish to always filter by the second value. How do I do this in code? Thanks in advance Paul Martin Melbourne, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter criteria | Excel Programming | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
Autofilter criteria not yet known | Excel Programming | |||
AutoFilter Criteria VBA | Excel Programming | |||
VBA Autofilter Criteria | Excel Programming |