automatically place the latest entry from a column into a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to automatically take the last number in a column and use it in a
formula. The column is a growing list of daily stock prices so the last
entry changes with each days update.
 
Try the SpecialCells method using the xlCellTypeLastCell constant.

YourRange.SpecialCells(xlCellTypeLastCell).Value

Hope this helps.

Bill Horton
 
Thanks, I tried that but it not going to the last cell of that column. Any
other suggestions? Also I may be doing it wrong trying to insert it into a
formula.
 
Where you want the last number from column A...

dim dblLastCell as double

dblLastCell= cells(rows.count, "A").end(xlUp)
msgbox dblLastCell
 
Back
Top