Advanced Filtering Problems

[GeekBlueNose]

Hi guys,

I would like to filter a table called Price_List by variable criteria.. The criteria is held in a table called Regions10..

This is the code I've written..

Please Login or Register  to view this content.

However it only filters by the first value in the Regions10 table and none of the others..


Any suggestions??

[AliGW]

Is this different to your other thread? Or is it all part of the same issue?

[GeekBlueNose]

I would normally use the Macro Recorder to to make my life easier.. But cannot because of the issue in my other post..

[AliGW]

OK - I'll let you keep this open, then. Thanks for clarifying.

[dangelor]

I believe the array needs to be 1-dimensional. A range is 2-D.

Try one of these...

Please Login or Register  to view this content.

[GeekBlueNose]

Hi Dangelor,

Thanks for your reply..

Not sure how this will work.. I can advance filter using my criteria through the manual route.. Before anyone says I can't record it as my excel is throwing up a lot of weirdness when I use the macro recorder as per another post of mine..

My criteria is in a single column on another sheet from the table that needs filtering..

Cheers,

[dangelor]

Try

Please Login or Register  to view this content.

[GeekBlueNose]

Just tried it... It worked.. I could kiss you right now.. But I'll give you some reputation points instead

[dangelor]

Glad I could help!