Help with automatically reading a column

Hi guys I hope everyone is well.

Im hoping that someone will be able to answer my query as I was trying to find the asnwer to it all day yesterday but didnt have any luck. Im basically wanting to write a VBA script for the following:

Everytime the script is run I want it to automatically read the result from column B and put the result in cell A1 eg

(the script is executed) it will read cell B1 and put "6" in A1
(the script is executed) it will read cell B2 and put "7" in A1
(the script is executed) it will read cell B3 and put "8" in A1
(the script is executed) it will read cell B4 and put "9" in A1 etc etc


A B
- 6
- 7
- 8
- 9

I basically need it to go through column B sequentially and automatically every time the script is run. Is this possible and if so what would be the best way to go about doing this?

Thanks in advance
Aaron

Cross-posted at VBAExpress http://www.vbaexpress.com/forum/showthread.php?t=33135

so the value at the bottom of column B goes into cell A1?

Don't waste your time, he has a solution at MrExcel. He is a time-parasite.