This will get the column number

=MAX(IF(ISBLANK(1:1),0,COLUMN(1:1)))

it is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew Mackenzie" wrote in message
...
Is there a way that I can make a cell reference the last occupied cell in
a
row. I guess I could use =IF but there are too many columns to use nested
"IF"s.