Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Name Define Help Please
Hello,
Could some one please help me with the following? From the tool menu - when I choose insert name define and enter the following criteria: Names in Workbook = jpgCells Refers to: ITEMS!$B$2,ITEMS!$B$21,ITEMS!$B$42,ITEMS!$B$63,ITE MS!$B$84,ITEMS!$B$105, ITEMS!$B$126,ITEMS!$B$147,ITEMS!$B$168,ITEMS!$B$18 9,ITEMS!$B$210,ITEMS!$ B$231,ITEMS!$B$252,ITEMS!$B$273,ITEMS!$B$294,ITEMS !$B$315,ITEMS!$B$336,I TEMS!$B$357,ITEMS!$B$378,ITEMS!$B$399,ITEMS!$B$420 ,ITEMS!$B$441,ITEMS!$B $462,ITEMS!$B$483,ITEMS!$B$504,ITEMS!$B$525,ITEMS! $B$546,ITEMS!$B$567,IT EMS!$B$588,ITEMS!$B$609,ITEMS!$B$630,ITEMS!$B$651, ITEMS!$B$672,ITEMS!$B$ 693,ITEMS!$B$714,ITEMS!$B$735,ITEMS!$B$756,ITEMS!$ B$777,ITEMS!$B$798,ITE MS!$B$819,ITEMS!$B$840,ITEMS!$B$861,ITEMS!$B$882,I TEMS!$B$903,ITEMS!$B$9 24,ITEMS!$B$945,ITEMS!$B$966,ITEMS!$B$987,ITEMS!$B $1008,ITEMS!$B$1029,IT EMS!$B$1050,ITEMS!$B$1071,ITEMS!$B$1092,ITEMS!$B$1 113,ITEMS!$B$1134,ITEM S!$B$1155,ITEMS!$B$1176,ITEMS!$B$1197,ITEMS!$B$121 8,ITEMS!$B$1239,ITEMS! $B$1260,ITEMS!$B$1281,ITEMS!$B$1302,ITEMS!$B$1323, ITEMS!$B$1344,ITEMS!$B $1365,ITEMS!$B$1386,ITEMS!$B$1407,ITEMS!$B$1428,IT EMS!$B$1449,ITEMS!$B$1 470,ITEMS!$B$1491,ITEMS!$B$1512,ITEMS!$B$1533,ITEM S!$B$1554,ITEMS!$B$157 5,ITEMS!$B$1596,ITEMS!$B$1722,ITEMS!$B$1743,ITEMS! $B$1764,ITEMS!$B$1785, ITEMS!$B$1806,ITEMS!$B$1806,ITEMS!$B$1827,ITEMS!$B $1848,ITEMS!$B$1869,IT EMS!$B$1890,ITEMS!$B$1911,ITEMS!$B$1932,ITEMS!$B$1 953,ITEMS!$B$1974,ITEM S!$B$1995,ITEMS!$B$2016,ITEMS!$B$2037,ITEMS!$B$205 8,ITEMS!$B$2079,ITEMS! $B$2100,ITEMS!$B$2121,ITEMS!$B$2142,ITEMS!$B$2163, ITEMS!$B$2184,ITEMS!$B $2205,ITEMS!$B$2226,ITEMS!$B$2247,ITEMS!$B$2268,IT EMS!$B$2289,ITEMS!$B$2 310,ITEMS!$B$2331,ITEMS!$B$2352,ITEMS!$B$2373,ITEM S!$B$2394,ITEMS!$B$241 5,ITEMS!$B$2436,ITEMS!$B$2457,ITEMS!$B$2478,ITEMS! $B$2499,ITEMS!$B$2520, ITEMS!$B$2541,ITEMS!$B$2562,ITEMS!$B$2583,ITEMS!$B $2604,ITEMS!$B$2625,IT EMS!$B$2646,ITEMS!$B$2667,ITEMS!$B$2688,ITEMS!$B$2 709,ITEMS!$B$2730,ITEM S!$B$2751,ITEMS!$B$2772,ITEMS!$B$2793,ITEMS!$B$281 4,ITEMS!$B$2835,ITEMS! $B$2856,ITEMS!$B$2877,ITEMS!$B$2898,ITEMS!$B$2919, ITEMS!$B$2940,ITEMS!$B $2961,ITEMS!$B$2982,ITEMS!$B$3003,ITEMS!$B$3024,IT EMS!$B$3045,ITEMS!$B$3 066,ITEMS!$B$3087,ITEMS!$B$3108,ITEMS!$B$3129,ITEM S!$B$3150,ITEMS!$B$317 1,ITEMS!$B$3192,ITEMS!$B$3213,ITEMS!$B$3234,ITEMS! $B$3255,ITEMS!$B$3276, ITEMS!$B$3297,ITEMS!$B$3318,ITEMS!$B$3339,ITEMS!$B $3360,ITEMS!$B$3381,IT EMS!$B$3402,ITEMS!$B$3423,ITEMS!$B$3444,ITEMS!$B$3 465,ITEMS!$B$3486,ITEM S!$B$3507,ITEMS!$B$3528,ITEMS!$B$3549,ITEMS!$B$357 0,ITEMS!$B$3591,ITEMS! $B$3612,ITEMS!$B$3633,ITEMS!$B$3654,ITEMS!$B$3675, ITEMS!$B$3696,ITEMS!$B $3717,ITEMS!$B$3738,ITEMS!$B$3759,ITEMS!$B$3780,IT EMS!$B$3801,ITEMS!$B$3 822,ITEMS!$B$3843,ITEMS!$B$3864,ITEMS!$B$3885,ITEM S!$B$3906,ITEMS!$B$392 7,ITEMS!$B$3948,ITEMS!$B$3969,ITEMS!$B$3990,ITEMS! $B$4011,ITEMS!$B$4032, ITEMS!$B$4053,ITEMS!$B$4074,ITEMS!$B$4095,ITEMS!$B $4116,ITEMS!$B$4137,IT EMS!$B$4156,ITEMS!$B$4179,ITEMS!$B$4220 There are too many cell references so I can not get this to work. Is there another way to define names with so many cell references? Any help would be greatly appreciated. Thanks, Chris. Live Long and Prosper :-) *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Name Define | Excel Discussion (Misc queries) | |||
insertnamedefine | Excel Discussion (Misc queries) | |||
InsertNameDefine | Excel Worksheet Functions | |||
Insert / Name / Define | Excel Discussion (Misc queries) | |||
Insert-Name-Define limit ? | Excel Discussion (Misc queries) |