WXP, SP2
XL2K2, SP3

What is the maximum number of range names one can have within a file without
running into issues to the point that Excel decides to say that the file has
been corrupted and goes into repair mode?

According to the specification help file, the only thing to limit Excel with
range names is the amount of memory, which I know I still have plenty of RAM
for the range names that were added to the various workbooks. The HD isn't
that full either as far as extended memory is concerned.

The first wave of 3 waves dealing with range names, the workbooks only
showed as being at a size between 8MB and 10MB, even after saving, which
after the first wave, it has something like 26k range names in it. The
second wave and the third wave both added another 26k or so of range names
each, which opened fine after the second wave, but then claims the workbooks
are damaged after the 3rd wave when you try to reopen those files. The
files now shows a size of between 11MB and 13MB, so it's still well below
the 160MB of MS's arbituary RAM usage limitation.

What brought on the need to put in range names?

With the changes that took place, it took the numbers out of alignment cause
cell refences within code doesn't adjust like cell references within
formulas does. Guess to overcome this issue, I will just have to name rows
and columns, then use long variables within VBA to get around both issues
(cell references not adjusted within VBA when rows/columns are
inserted/deleted and apparently to avoid reaching the maximum number of
range names allowed within a single workbook that seems to be somewhere
between 52k and 78k).

Sincerely,

Ronald R. Dodge, Jr.