Combine all Named Ranges into one Named Range

[thinkspac]

Hey Guys,

I have 11 Named Ranges (all near or at capacity) in a workbook and I am writing some code that will do different things with those Named Ranges. Instead of something like the following:

Please Login or Register  to view this content.

and having to list each range and repeat code, is there a way to combine all of my named ranges into a range/string?

I have tried this one below, but it does not work :

Please Login or Register  to view this content.

I couldn't get any of this to work either:

Please Login or Register  to view this content.

My ultimate goal is to use - Range("XXX").Select, where "XXX" references all named ranges I define in my workbook. Hopefully someone can tell me what I am missing or a better way to call them.

[shg]

Please Login or Register  to view this content.

[thinkspac]

Thanks for the reply shg, and Howdy from East Texas!

I am not sure exactly how that code would work. Any time I try to include multiple Named Ranges into one range(), the code fails.

Here is an example-

This Based on a dropdown selection in a cell, a macro is called and runs a Sub similar to:

Please Login or Register  to view this content.

However, if I attempt to add more than 1 Named Range, the code fails with Method 'Range' of object '_Global' failed.

[shg]

Post a workbook that illustrates the problem.

[thinkspac]

Figured out my error - I did not realize that the Named Ranges were case sensitive when called in VBA.

[shg]

They're not ...

[CowtownWizard]

I just encountered this 13 year old thread today when I went in search of a way to combine seven named ranges into one logical named range. I suppose I could manually combine them into one disjoint range, since the ranges are not adjacent to each other, but I hoped for something a tad simpler, so that I can use the aggregated range in four worksheet formulas to get the overall count, minimum, maximum, and average of the cells in the seven ranges.