Did you select the cells before entering the range name in the box?

Click on the drop arrow on the name box and select your name.

The cells will be selected.

Note: There is a 255 character limit to the "Refers to" address so it may be
difficult to fit in 109 if non-contiguous.


Gord Dibben MS Excel MVP

On Sun, 16 Jul 2006 15:21:02 -0700, Skydiver
wrote:

Hi Martin,

Okay, I followed the steps and added a range name in the name box, but
nothing happened. The instructions don't mention anything about saving it or
what to do after I enter a range name. I have 109 cells for data entry.
Helllllp.

John

"MartinW" wrote:

Hi John,

The name box is to the left of your formula bar at the top left
of your screen. It tells you the name of the active cell.
To input the range name as Ragdyer suggests just click in the
name box. When you want to activate the range name
click on the pulldown arrow at the right of the box and
select the name that you inputted earlier.

HTH
Martin