bottom of column value retrival

[Alan]

Hi,

I have a workbook with two sheets. i need one sheet to
retrieve a cell value (currency) at the bottom of a column.

the bottom of the column will move every few days.


How can i do this?

Mant Thanks

 

[John Wilson]

Alan,

Range("A" & Rows.Count).End(xlUp).Value

Will return the last non-blank cell value in Column A

John

 

[Frank Kabel]

Hi Alan
one solution (assuming your A is your column)
=INDEX(A:A,COUNTA(A:A))
Frank

 

[Alan]

Range("A" & Rows.Count).End(xlUp).Value

how do i put this in excel?

Thanks