Help says:
"If reference is a range of cells, and if COLUMN is entered as a horizontal
array, COLUMN returns the column numbers of reference as a horizontal
array."
If you enter only the first element of that horizontal array, you'll get the
first element of the result, i.e. COLUMN(A9), which is 1. If you extend it
to a horizintal array, you'll get 1, 2, 3, .... etc.
--
David Biddulph

"Dave F" wrote in message
...
This function returns 1: =COLUMN(9:9). I would expect it to return an
error,
being that row 9 is not, in fact, a column.

What's happening here?