Last Numeric in a Column?
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
|