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" wrote in message
...
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" wrote in message
...
Hi Niek,

I think I got one issue solved. ToolsOptionsCalculations 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" wrote in message
...
| 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