Building an array to use in Autofilter

[brucemc777]

The following code works:

Please Login or Register  to view this content.

But I want to dynamically assign that array from cell values. My shot at it (well, multiple shots at it, ending in...):

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

suck canal water.

As these values can change I need to be able to dynamically assign them and I know whatever it is, I am missing something painfully obvious, but I just can't put my finger on it.

Can someone show me where I messed up?

Thank-you!

[Norie]

When you create an array from a range it's 2-dimensional, the array for the filter needs to be one-dimensional.

Try transposing the array.

Please Login or Register  to view this content.

[brucemc777]

WoW!

OK, I now really MUST run off to work, but how did that solve the problem? (In other words, it sure did!!!)