Row() function returns wrong row and more..

Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
Currency Tools loaded.

Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns
#NAME?. Existing workbook returns "11". (I move text and the row changes,
but always one higher than actual row. I've verified no hidden rows on
worksheet

I can deal with the "one row off" thing with code but can't figure out the
difference in files.

Any clue where I'm failing to understand what's happening?

Thanks,

Kim

Hi Kim,

If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell
address.
The ROW() function needs a Range reference, either a cell address(ses) or a defined name.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kim" <[email protected]> wrote in message news:[email protected]...
| Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
| Currency Tools loaded.
|
| Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns
| #NAME?. Existing workbook returns "11". (I move text and the row changes,
| but always one higher than actual row. I've verified no hidden rows on
| worksheet
|
| I can deal with the "one row off" thing with code but can't figure out the
| difference in files.
|
| Any clue where I'm failing to understand what's happening?
|
| Thanks,
|
| Kim

Hi Niek,

I think I got one issue solved. Tools>Options>Calculations select "Accept
Labels in Formulas" lets me put "kim" into row(). It still returns one row
higher than actual text but I'm closing in...........

Thanks for you help!

Kim

"Niek Otten" wrote:

> Hi Kim,
>
> If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell
> address.
> The ROW() function needs a Range reference, either a cell address(ses) or a defined name.
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Kim" <[email protected]> wrote in message news:[email protected]...
> | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
> | Currency Tools loaded.
> |
> | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns
> | #NAME?. Existing workbook returns "11". (I move text and the row changes,
> | but always one higher than actual row. I've verified no hidden rows on
> | worksheet
> |
> | I can deal with the "one row off" thing with code but can't figure out the
> | difference in files.
> |
> | Any clue where I'm failing to understand what's happening?
> |
> | Thanks,
> |
> | Kim
>
>
>

Go to,
<Insert> <Name> <Define>

And see if there's a "Kim" defined there.
If yes, click on it and see what's in the "Refers To" box.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Kim" <[email protected]> wrote in message
news:[email protected]...
Hi Niek,

I think I got one issue solved. Tools>Options>Calculations select "Accept
Labels in Formulas" lets me put "kim" into row(). It still returns one row
higher than actual text but I'm closing in...........

Thanks for you help!

Kim

"Niek Otten" wrote:

> Hi Kim,
>
> If you select A11, you'll see "Kim" in the Name box (right above A1). This
is a defined name, which you can use instead of a cell
> address.
> The ROW() function needs a Range reference, either a cell address(ses) or
a defined name.
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Kim" <[email protected]> wrote in message
news:[email protected]...
> | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
> | Currency Tools loaded.
> |
> | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns
> | #NAME?. Existing workbook returns "11". (I move text and the row
changes,
> | but always one higher than actual row. I've verified no hidden rows on
> | worksheet
> |
> | I can deal with the "one row off" thing with code but can't figure out
the
> | difference in files.
> |
> | Any clue where I'm failing to understand what's happening?
> |
> | Thanks,
> |
> | Kim
>
>
>

RD,

New workbook/worksheet. Sheet1. No names -- no nothing in fact except for
my test entries.

Kim

"RagDyeR" wrote:

> Go to,
> <Insert> <Name> <Define>
>
> And see if there's a "Kim" defined there.
> If yes, click on it and see what's in the "Refers To" box.
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "Kim" <[email protected]> wrote in message
> news:[email protected]...
> Hi Niek,
>
> I think I got one issue solved. Tools>Options>Calculations select "Accept
> Labels in Formulas" lets me put "kim" into row(). It still returns one row
> higher than actual text but I'm closing in...........
>
> Thanks for you help!
>
> Kim
>
> "Niek Otten" wrote:
>
> > Hi Kim,
> >
> > If you select A11, you'll see "Kim" in the Name box (right above A1). This
> is a defined name, which you can use instead of a cell
> > address.
> > The ROW() function needs a Range reference, either a cell address(ses) or
> a defined name.
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> > Microsoft MVP - Excel
> >
> > "Kim" <[email protected]> wrote in message
> news:[email protected]...
> > | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
> > | Currency Tools loaded.
> > |
> > | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns
> > | #NAME?. Existing workbook returns "11". (I move text and the row
> changes,
> > | but always one higher than actual row. I've verified no hidden rows on
> > | worksheet
> > |
> > | I can deal with the "one row off" thing with code but can't figure out
> the
> > | difference in files.
> > |
> > | Any clue where I'm failing to understand what's happening?
> > |
> > | Thanks,
> > |
> > | Kim
> >
> >
> >
>
>
>

I'm talking about the sheet (existing) where you get a return of 11 when you
enter =row(kim) in D2!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kim" <[email protected]> wrote in message
news:[email protected]...
> RD,
>
> New workbook/worksheet. Sheet1. No names -- no nothing in fact except
> for
> my test entries.
>
> Kim
>
> "RagDyeR" wrote:
>
>> Go to,
>> <Insert> <Name> <Define>
>>
>> And see if there's a "Kim" defined there.
>> If yes, click on it and see what's in the "Refers To" box.
>> --
>>
>> HTH,
>>
>> RD
>> =====================================================
>> Please keep all correspondence within the Group, so all may benefit!
>> =====================================================
>>
>> "Kim" <[email protected]> wrote in message
>> news:[email protected]...
>> Hi Niek,
>>
>> I think I got one issue solved. Tools>Options>Calculations select
>> "Accept
>> Labels in Formulas" lets me put "kim" into row(). It still returns one
>> row
>> higher than actual text but I'm closing in...........
>>
>> Thanks for you help!
>>
>> Kim
>>
>> "Niek Otten" wrote:
>>
>> > Hi Kim,
>> >
>> > If you select A11, you'll see "Kim" in the Name box (right above A1).
>> > This
>> is a defined name, which you can use instead of a cell
>> > address.
>> > The ROW() function needs a Range reference, either a cell address(ses)
>> > or
>> a defined name.
>> >
>> > --
>> > Kind regards,
>> >
>> > Niek Otten
>> > Microsoft MVP - Excel
>> >
>> > "Kim" <[email protected]> wrote in message
>> news:[email protected]...
>> > | Using 2003 w/SP2, all current updates, nothing disabled and all but
>> > Euro
>> > | Currency Tools loaded.
>> > |
>> > | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2
>> > returns
>> > | #NAME?. Existing workbook returns "11". (I move text and the row
>> changes,
>> > | but always one higher than actual row. I've verified no hidden rows
>> > on
>> > | worksheet
>> > |
>> > | I can deal with the "one row off" thing with code but can't figure
>> > out
>> the
>> > | difference in files.
>> > |
>> > | Any clue where I'm failing to understand what's happening?
>> > |
>> > | Thanks,
>> > |
>> > | Kim
>> >
>> >
>> >
>>
>>
>>