Fetch Autofilter options
- From: ashish128 <ashish128@xxxxxxxxx>
- Date: Thu, 11 Oct 2007 02:49:34 -0700
Hi to all,
I didnt knew what to type to search and therefore am posting this
request.
Whenever we autofilter a range and select any field then we get a
dropdown list of unique entries in that field.
1. If there is only one item then how to get that.
eg.
A
5
5
5
5
If I autofilter on column A then it will only contain 5. How can I
get
this value using VBA
2. how to get all of the the autofilter options?
eg.
A
1
2
3
1
2
3
1
2
3
if I autofilter on column A then the available options will be
A
1
2
3
howto get them using VBA.
Kindly advice.
With Regards
Ashish Sharma
.
- Follow-Ups:
- RE: Fetch Autofilter options
- From: Tom Ogilvy
- RE: Fetch Autofilter options
- Prev by Date: Re: Text file created from Excel
- Next by Date: Re: Data Ranges
- Previous by thread: RE: sign a macro with microsofts ca
- Next by thread: RE: Fetch Autofilter options
- Index(es):
Relevant Pages
|
