VBA Filter Using Named Ranges as Criteria

I am trying to filter data by named range critera. For instance, in column B, cells fall into various named ranges (B2, B10, and B12 belong to named range "FirstNamedRange"; B4, B10, and B8 belong to "SecondNamedRange"; and B22, B23, and B25 belong to "ThirdNamedRange"). As you can see from these examples, not all cells in column B are assigned to a particular named range, and cell B10 belongs to both FirstNamed Range and SecondNamedRange.

I want to filter by a specified named ranges but cannot figure out how to indicate a named range as the criteria. Below are some codes that I have tried with no success - mismatch errors, no critera pulled, etc. To give you a general idea of my plans for this piece of code, I am going to use it to filter and show all cells belonging to FirstNamedRange and then I will use it to build a code to filter and show all cells belonging to FirstNamedRange OR SecondNamedRange, then FirstNamedRange AND SecondNamedRange....That kind of idea.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you in advance for any help you can provide. Any forum threads I have found on the internet on this subject have proven unhelpful.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I don't think you can't use a non-contigous range to filter by, all your ranges are non-contiguous.

Also, none of them include the header.

Perhaps you should copy the criteria to another range and then filter by that.

Please Login or Register  to view this content.

The UsedRange part is your code which I didn't touch, it's referring to the intersection between column B on the worksheet and the used range on the worksheet.

Item(1) refers to Range("L1") and probably isn't needed now that I think about it, Rezise should work on it's own.