Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass Creation of Named Ranges?
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
Absolute Named Ranges???? | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |