The cell references MUST be absolute

The named range method is limited to 255 characters in the "refers to"
dialog box.

This counts all those d..ned repeated sheet names.

Here is a method to get about 46 cells in the box.

=$B$2,$D$2,$F$2,$H$2,$J$2,$B$4,$D$4,$F$4,$H$4,$J$4 ,$B$6,$D$6,$F$6,$H$6,$J$6,$B$8,$D$8,$F$8,
$H$8,$J$8,$B$10,$D$10,$F$10,$H$10,$J$10,$B$12,$D$1 2,$F$12,$H$12,$J$12,$B$14,$D$14,$F$14,$H$14,
$J$14,$B$16,$D$16,$F$16,$H$16,$J$16,$B$18,$D$18,$F $18,$H$18,$J$18,$L$3

As an extra hint. In the example above all of the cell references are
absolute. Typing all of that out can be time-consuming and difficult. It
would be easier to enter the cell references as relative references
(=B2,D2,F2, etc.), and then convert them to absolute simply by hitting F2 to
enter edit mode, select the complete string, and then F4 to convert to
absolute. Further F4s will convert to relative/absolute, absoulte/relative,
and then back to relative.


Gord

On Fri, 12 Sep 2008 07:57:01 -0700, Jessica Donadio
wrote:

Hi, thank you for your advice. I tried this, and it would be ideal, but the
only drawback I am facing is that I would like this order to be constant for
each row. In other words, I want that when I input a new contact's record,
and it's a magazine as opposed to a hotel, I want to jump to A to C to D to M
to N. I don't know if my version of excel is old, but when I take away the
absolute reference signs, it doesn't quite work the way it should, and I
somewhat obtained the correct order, but for one reason or other, the
highlighted cells jump one row higher than the cell I select to insert new
data. Also, I would like to apply say 50 rows to the array with this cell
order because I would be inserting the magazine data successively and would
prefer not to select the named range at the beginning of each record. Is
this possible? After I had selected a nember of the cells in 4 or 5 rows,
despite selecting all of them in the right order, the named range did not
highlight the right cells, so it doesn't seem to handle so many. Any advice
would be appreciated.

"Gord Dibben" wrote:

Jessica

You could use a named range and no sheet protection.

Select second cell in the sequence then with CTRL key held down select the
next ones in turn ending off your selection with the first in sequence.

InsertNameDefine...........give your range a name like doodah and OK

In NameBox select doodah and start entering data.