Hi there ,
I'd like to filter data ( or a Named range ) in a worksheet based on multiple selected items in a listbox on a userform.
This is the code i use now to create a kind of array to be used in the Autofilter function.
No error if code is run , Autofilter is activated , but i have no results.
Can someone help me with this issue ?
Thanks
MarMo
Please Login or Register to view this content.
Last edited by MarMo; 01-08-2013 at 08:41 AM.
hi MarMo,
Please Login or Register to view this content.
watersev ,
Works like a charm. Thanks for that.
It is so great that people give a solution on this forum.
And for my learning purposes , could you give a small explaination for the following code please ?
Why the use of the pipe ( or vertical bar )
I'm eager to learn new things and to write better code.
Many thanksPlease Login or Register to view this content.
MarMo
watersev ,
Works like a charm. Thanks for that.
It is so great that people give a solution on this forum.
And for my learning purposes , could you give a small explaination for the following code please ?
Why the use of the pipe ( or vertical bar )
I'm eager to learn new things and to write better code.
Many thanksPlease Login or Register to view this content.
MarMo
you get a string delimited with pipe, after splitting it by pipe you get an array
watersev ,
Thanks again for the explaination.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks