Your formula depends on C1 being empty.

Try that suggestion in my earliest response.

You could adjust the formula to always subtract 1, but then if C1 is emptied,
you'll have a different problem.

Robin wrote:

Dave,

I clicked F5 and then i noticed the the list range plus the addition of
the C and D cell below list was surrounded by a black bold border. Thank you
again.

"Dave Peterson" wrote:

The formula works perfectly for me.

I don't have any other guesses why it's not working for you.

But you didn't really answer my question about any typos in the worksheet name.

Try changing the worksheet name to A (a single character).

Then check the name to see what it refers to. Excel is smart enough to adjust
it to:
=OFFSET(A!$C$2,0,0,COUNTA(A!$C:$C),2)

If you don't see that new formula, then the name of the worksheet isn't
"Measure". There's a typo somewhere.

Robin wrote:

Dave this is the formula that I was given to use
=OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C),2)
I want the initial cell to be C2 .
The initial row is C2 and D2 C2 is a list of words and D2 is a list of
corresponding abbreviations. I have typed the list to the cells C234 and
D234. I would like the cells to extend equally for as long as is appropriate
I think 100 would cover any additions that they might have. for C2 and D2
thus allowing the user to type any additions that they might have. I know tha
the 2 added prior to the last parenthesis is due to updating the range of 2
columns.
Is it that the row range that needs to be changed to an additional 100 be
included in the formula?

I also have the Measure sheet selected when I am updating the formula.

Does the Scope selection have any thing to do with this?

Concerning this legal stuff is there something I need to change in the
formula.

You have helped me for a long time and I thank you.

Robin.

"Dave Peterson" wrote:

If your formula evaluated to use start in Row 1 but extend the range to 12 rows,
that would be legal.

But if that formula evaluated to start in row 1 but extend for 0 or a negative
number of rows, then that would not be legal.

Are you sure that the worksheet is named Measure?

Maybe there's a spelling error (or an extra space character at either end???

Robin wrote:

C1:D1 is a topic

Cells C ARE words andCells D are abbreviations. I do not know what a legal
range reference.

"Dave Peterson" wrote:

What's in column C?

If there's not enough to count, then you may not have a legal range/reference.

ps. If you're not sure what's in C1 all the time, you may want to use a formula
like:

=OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C)-COUNTA(Measure!$C$1),2)

Then the range (if it's legal!) will start in row 2.

Robin wrote:

I have a range from C2:D234. The column C has a heading of term and Column D
is the abbreviaton. I want the cells starting wiht C235 and D 235 to be able
to have additions made by the user. I have been given instructions to do the
following

have 2007 version and I have gone to Formulas tab and then select name
define
Then I type in DynAbbrMeasure
I select list (is there something else that I should select?)
I then Paste =OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C),2)
Click ok
Press F5
In the go to box it states D236:D236
I type in DynAbbrMeasure
It states that the Reference is not valid

What am I doing wrong? The end of the typed list is C 234 & D 234 and I
would like the range to be added to and an indefinite range. I would
appreciate your help with this.

Sincerely,

Robin

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson