Re: Add a second range to a scripting dictionary
Quote from Bryan021;793307Kris,
Thanks for the response.I'm not seeing how this is a solution though... isn't "Intersect" looking at the value(s) within the intersection of two (or more) ranges... I'm working with two separated columns (never intersecting).
Maybe I wasn't clear about what I want to achieve.
On the active sheet I have Column L with a list of city names, and Column U with another list of city names.
From the combined data of these two columns, I want to end up with a list of unique city names in Column F of a different sheet ("Data").What I currently have works well for extracting the unique city names in Column L, I just need to add any other unique cities from Column U that do not appear in Column L.
Have you tested what I suggested ?