i keep getting the error:

run-time 13, type mismatch??


"Tom Ogilvy" wrote in message
...
If your formula is a User defined function, use application.Caller

Public Function MyFunc()
set rng = Application.Caller
Myfunc = rng.column
End Function

as a trivial example.




--
Regards,
Tom Ogilvy

mark kubicki wrote in message
...
how do i get the column number of the cell that my formula is written in

guess it's not: activecell.column