automatically place the latest entry from a column into a formula

[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.

 

[Guest]

Try the SpecialCells method using the xlCellTypeLastCell constant.

YourRange.SpecialCells(xlCellTypeLastCell).Value

Hope this helps.

Bill Horton

 

[Guest]

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.

 

[Guest]

Where you want the last number from column A...

dim dblLastCell as double

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