Autofilter with Loops

[kaon]

Hi all,

Is there any quick ways that I can obtain all available options of eac
fields? (as shown in the attachment)

If not, any idea. I just came up using CountA() to get each distinc
options

Attachment filename: autofilter.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=64478

 

[Dave Peterson]

John Walkenbach shows how to get a list of unique values from a range to
populate a listbox.

Maybe you could change his code:

http://j-walk.com/ss/excel/tips/tip47.htm

(I didn't look at the attachment.)

 

[kaon]

Ouch~ Tough that's not what I want excatly, but it still works!

Thanks, guy!