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

"dakotasky" wrote:

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.

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.

"William Horton" wrote:

Try the SpecialCells method using the xlCellTypeLastCell constant.

YourRange.SpecialCells(xlCellTypeLastCell).Value

Hope this helps.

Bill Horton

"dakotasky" wrote:

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.

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

dim dblLastCell as double

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

Jim Thomlinson


"dakotasky" wrote:

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.

"William Horton" wrote:

Try the SpecialCells method using the xlCellTypeLastCell constant.

YourRange.SpecialCells(xlCellTypeLastCell).Value

Hope this helps.

Bill Horton

"dakotasky" wrote:

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.