I am developing a VBA program that will go through a filtered list and do
query on multiple columns. I need to create an array of the filter values
from several columns.

How do I create a list of the values for a given column?

Thanks for your help,

Gary

Hi Gary,

I am developing a VBA program that will go through a filtered list
and do query on multiple columns. I need to create an array of
the filter values from several columns.

How do I create a list of the values for a given column?


Dim arr As Variant
Dim i As Long

arr = Array("Pippo", "Pluto", "Papperino")

For i = LBound(arr) To Ubound(arr)
'Fa qualcosa, e.g.;
msgbox arr(i)
Next i






---
Regards,
Norman



"gary" wrote in message
...
I am developing a VBA program that will go through a filtered list and do
query on multiple columns. I need to create an array of the filter values
from several columns.

How do I create a list of the values for a given column?

Thanks for your help,

Gary

Are you looking for that list of unique items that you see when you use the
arrow on an autofiltered column?

If yes, you could use data|Filter|advance filter and filter to a new location (a
different worksheet). Debra Dalgleish shows how to do it manually:

http://www.contextures.com/xladvfilter01.html#FilterUR

You could record a macro when you did it manually if you need code.

======
An alternative, John Walkenbach shows how to fill a listbox with a unique list:
http://j-walk.com/ss/excel/tips/tip47.htm



gary wrote:

I am developing a VBA program that will go through a filtered list and do
query on multiple columns. I need to create an array of the filter values
from several columns.

How do I create a list of the values for a given column?

Thanks for your help,

Gary

--

Dave Peterson