View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Row() function returns wrong row and more..

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