I have a range I'm defining in the name manager, and when I enter the formula

OFFSET(a1,0,0,count(a:a),10)

then shft-tab/tab to get the blinking highlight of what it's defining, it's
clearly seeing the right range.

however, three problems:

1) when I go to the named range dropdown, the newly created range isn't there
2) when I use it in a vlookup to test, it only recognizes the range as a
1-column range
3) as soon as I save the range as the formula above, it automatically
converts to

OFFSET([sheet]A1,0,0,count([sheet]a:a,10)

Any of these problems explainable (I can understand (3), but not the
others)? Am using 2003.
--
Boris