I've have this Excel VBA script working now to where it pulls in a section of hundreds of other spreadsheets.

The range it pulls and adds to a new Workbook is about 15 columns by 10 rows big. (so it will end up with hundreds of these copied ranges on a sheet). The range areas are all the same size and have the same layout.

Each range that I've copied is like a data matrix. But, despite their size, I already know there are only about 15 different possiblities of how they will look.

The data part of them can have about 5 different values that are alpha numeric (i.e. 'B', '1', '0','Y','N').

What I need to do is to scan everyone of those grids (15x10 ranges) and give them a label for sorting.

I've been thinking of ways to do this. I can only think of maybe using arrays to compare every single ranged aread. I know off hand one thing that hurts me is that it's not possible to redim anything but a single dimension array. I figure since I don't know how many grids will get pulled I'll have to redim, meaning I would need a massive amount of single dimension arrays.

Is there some quick way of comparing a large number of ranges on a spreadsheet to find out which ones match each others?

Thanks for any help?