Maximum size of range object Windows vs Mac

[crashcb18]

All,
I wrote a code on my Mac Excel 2011 in which I had a range object that was a union of numerous other ranges (each was 1Rx141C). The code worked fine on my Mac. Then, when I ran it on Windows Excel 2010 (or maybe 2007), it rejected the code. During debugging, i noticed if I shortened that range object that was a union of other ranges, it worked. If I added another original range (one row with 141 cells), then it wouldn't work.

Is there a maximum size of one range?

 

[mikerickson]

There is a maximum number of columns, but its greater than 255 in all versions of Excel.
How many Areas are there in the resulting range?
Are you doing anything odd, like making a union of intersecting ranges where the result is an odd shape.
E.G. Appliacation.Union(Range("A1:D10"), Range("C3:E15"))