View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_56_] Jeff[_56_] is offline
external usenet poster
 
Posts: 3
Default 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