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
|