And dont forget that you can nest names ;
jpgCells defined as jpgCells1,jpgCells2 .....

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Susan" wrote in message
ups.com...
WOWEE!!!!!
|:0
name several smaller regions.......
jpgcells1
jpgcells2
jpgcells3
it may mean a slightly longer formula somewhere, but that should
help........
:)
susan


On Mar 28, 7:31 am, Longbow wrote:
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 Developersdexhttp://www.developersdex.com***