automatically place the latest entry from a column into a formula

[dakotasky]

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.

[William Horton]

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.

[dakotasky]

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.

[Jim Thomlinson]

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.