If Excel can get to 65,407 rows with names then it sure as hell can
finish the last 100 or so...I don't think this is an issue with my
memory for I have 1 gig of it in my computer. If there is someone with
enough intelligence to give me a script to insert to pull the names and
jump to the next line I would be most appreciative...

Peter T wrote:
The number of names in a workbook is "limited by available memory". Either
that is the reason for your problem or whatever code you are using to create
names is eventually trying to create an invalid name.

That aside your approach will lead you to other problems.

Regards,
Peter T

wrote in message
ps.com...
Hey all,

I am trying to setup of a worksheet that has ranges A:F as a named
ranged using the name "DB1_#" (# = Cells 1 - 65535), I have noticed
that when I try to create a mass quantity of named ranges Excel craps
out on me at around 65407...anyone have any idea as to why this is or
if there is a macro I could run to create a worksheet with 65535 named
ranges using that setup? See example below if your confused...


ROW 1: DB1_1 (Ranges A:F)
ROW 2: DB1_2 (Ranges A:F)
ROW 3: DB1_3 (Ranges A:F)
ROW 4: DB1_4 (Ranges A:F)


|||||||||||||||||||||||||||||


ROW 65536: DB1_65536 (Ranges A:F)


Thank you kindly!