ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Max # of named ranges (https://www.excelbanter.com/excel-discussion-misc-queries/35353-max-named-ranges.html)

leaftye - ExcelForums.com

Max # of named ranges
 
What is the max # of named ranges on a worksheet? On a workbook? Is
there a limit to the number of named ranges that can be referenced
via a mail merge? TIA!

Eugene


FSt1

hi,
In excel help type the word specifications.

Names in a workbook - Limited by available memory

as to the mail merge part, you may have to look up specifications in Word.
not listed in excel or i missed it.

FSt1

"leaftye - ExcelForums.com" wrote:

What is the max # of named ranges on a worksheet? On a workbook? Is
there a limit to the number of named ranges that can be referenced
via a mail merge? TIA!

Eugene




All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com