named range limits?

J

jc

hi. is there a limit to the number of named ranges i can
add to a spreadsheet?

i'm working on a fairly large project and don't want to
hit the proverbial brick wall when I'm halfway through.

thanks in advance. jcm
 
N

Niek Otten

Excel Help, Specifications and limits: limited only by available memory.
I have some workbooks with well over a thousand named ranges.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
G

Guest

thanks niek!
-----Original Message-----
Excel Help, Specifications and limits: limited only by available memory.
I have some workbooks with well over a thousand named ranges.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel




.
Click to expand...
 
Top