Combining Multiple Named Ranges

[ptmuldoon]

I'm working at changing over some macros from looking at Cell ranges to Named ranges, and wondering on the best approach.

I'm currently using UNION to combined the ranges. But is there something better? The below is just a sample combining 2 ranges, but it will expand to be combining about 10 different named ranges.

The goal is to 'protect' the macro if the user inserts any rows or columns on me. Below is piece of the code in trying to explain what I'm doing

Please Login or Register  to view this content.

[stnkynts]

There is a Names collection. Not sure it that will help you out but you can loop through each named range:

Please Login or Register  to view this content.

Please Login or Register  to view this content.