Cell References
 

How would i wright some code which would check column A from the top
downwards for a value and if it found a value store that value in a variable
and then keep checking column A for another value and then store the next
cell reference in another variable?