With a base of Win/XP Prof. and Excel 2002, I entered some test data in A8 thru F15, did an insert/name/define, used a name of "testrange" (w/o quotes), and entered the following formula;
=OFFSET(Sheet1!$A$8,0,0,COUNTA(Sheet1!$A:$A),6)
in the refers to field. My questions are;
1. why doesn't this name show up in the named range field, the field to the left of the formula bar?
2. when I am entering the above formula and try to edit by moving the cursor with the arrow keys, Excel starts plugging in additions to the formula. Is this a bug or MS feature?
3. if I copy that formula and paste it in a cell, it displays as #VALUE. Shouldn't it show a range?
=OFFSET(Sheet1!$A$8,0,0,COUNTA(Sheet1!$A:$A),6)
in the refers to field. My questions are;
1. why doesn't this name show up in the named range field, the field to the left of the formula bar?
2. when I am entering the above formula and try to edit by moving the cursor with the arrow keys, Excel starts plugging in additions to the formula. Is this a bug or MS feature?
3. if I copy that formula and paste it in a cell, it displays as #VALUE. Shouldn't it show a range?