Hi Chris,

Manually or programmatically with a string address, defining or editing a
Name is limited to 255 characters. In practice can be less than that.

In code you can define the name to that refer directly to a range. The limit
is between 149 and 224 multiple areas depending on the combination of single
or multiple cells in each area. The limit is not related to length of
address.

Sub test()
Dim rng As Range
Dim i As Long

Set rng = Range("A1:B1")

For i = 3 To 298 Step 2
Set rng = Union(rng, Range(Cells(i, 1), Cells(i, 2)))
Next

ActiveWorkbook.Names.Add "LongName", rng

Set rng = Nothing

Set rng = Range("LongName")

rng.Select

MsgBox rng.Count & " cells" & vbCr & _
rng.Areas.Count & " areas" '149

End Sub


There's no way to manually edit a name with that many areas. However with
fewer, it may help to temporarily rename the sheet to a single letter.

There are other ways (lot of code) to define a name with much more than the
149/224 limit, though I limit to 3,600 areas for practical reasons.

Regards,
Peter T

"Longbow" wrote in message
...
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 ***