There is no need to write code. Bob Phillips has collected some of the
cleverest methods posted in the news groups at his site:

http://xldynamic.com/source/xld.LastValue.html

--
Regards,
Tom Ogilvy


"Jeff" wrote:

Hi all. Could anyone help me make a vba function, that returns the
last numeric (positive or negative) cell in a column.
for example in range (F6:F19):

cell value
F6 5
F7 10
F8 100
F9 169
F10 -
F11 -
.. -
.. -
.. -
F19 -

F20 =LastNumInColumn (F6:F19) OR 169
Please Note : "-" is a hypen

Thanks in advance guys.

Jeff