Select a range within a column

Hello jomili,

Maybe this code is what you need...

Please Login or Register  to view this content.

I've got the PertPacs1 working for View 2, but am now having trouble with View3, as the code I'm using doesn't appear consistent in this view. Here are the pertinent macros:

These first two are the good, working macros for View2:

This one Filters the first column, creates named range for second - works well

Please Login or Register  to view this content.

This one adds the range for my second column to my "temp" worksheet, deletes the duplicates, defines the name range - works well

Please Login or Register  to view this content.

The next two are my attempts for View3, where we have 3 dropdown fields, so need 2 Named Ranges to populate the 2nd and 3rd dropdowns. They're basically the same as the code above, but they don't work and I can't figure out why.

Filter the first column, create named range for second - works intermittently; haven't even tried 3rd column yet.

Please Login or Register  to view this content.

This one adds the range for my second column to my "temp" worksheet (it's quite alright that it overwrites what was previously there), deletes the duplicates, defines the name range - sometimes works, but usually defines the range as only containing A1, even when there are 3-4 cells in the column with discreet values. I haven't even attempted the third dropdown choice yet.

Please Login or Register  to view this content.

I've attached my workbook, and please let me know of any other explanation I can provide.

Thanks,
John