ExcelBanter - read value of last cell in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - read value of last cell in column (https://www.excelbanter.com/excel-programming/309480-read-value-last-cell-column.html)

S.E.

read value of last cell in column

How do I read the value of the last cell (the bottom one) in a given column?

Scott

Tom Ogilvy

read value of last cell in column

msgbox Cells(rows.count,"A").End(xlup).Value

--
Regards,
Tom Ogilvy

"S.E." wrote in message
...
How do I read the value of the last cell (the bottom one) in a given
column?

Scott

All times are GMT +1. The time now is 03:22 PM.