View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
 
Posts: 284
Default 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