I'm perplexed about a situation with range names and referring to them.
If I create an array and sort by Column A to get "like" cells aligned, then create ranges on each group of "like" cells, then I can call those ranges by name in a macro. What if I then take my array and sort it by another column, say Column B. Now the contiguous rows that were in the original array are no longer in the array contiguously. What happens when I then refer to the range name in the macro?