Row() function returns wrong row and more..

K

Kim

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
 
N

Niek Otten

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

| 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
 
K

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
 
R

RagDyeR

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!
=====================================================

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 said:
Hi Kim,

If you select A11, you'll see "Kim" in the Name box (right above A1). This
Click to expand...
is a defined name, which you can use instead of a cell
 
K

Kim

RD,

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

Kim
 
R

Ragdyer

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