On Excel 2007 and 2010 there is a selection form on the auto filter
The selection form allows the user to select a number of entries to use as a filter.
I need to use the same mechanism on an internal array in VBA
In effect, I want to have an initial array where the autofilter user form appears and allows the user to select which items I require. On accepting the selections, I would require a smaller array that included only the items matching the selection.
What is the VBA function/call that will allow me to use this mechanism on an array, rather than a column in a table?
Thanks in advance
Ian
Bookmarks