Help With automatically reading a column

[Aarondo]

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

[Bob Phillips]

Cross-posted at Xtreme VBTalk http://www.xtremevbtalk.com/showthread.php?t=317077

[Bob Phillips]

... and MrExcel http://www.mrexcel.com/forum/showthread.php?t=481927