named range limits?

[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

 

[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

 

[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




.