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!