This is a method of referencing cells that I haven't seen mentioned in the forums (some one will correct me if I'm wrong)
It's saved me a few times and is a great way of looping thru a range of cells in code or picking an offset cell value.
range("b2:d3") (1,1).value = (value of b2)
range("b2:d3") (2,2).value =(value of c3)
range("b2:d3") (6,1).value= (value of b7)
range("a1:a10") (2).value = (value of a2)
Credit to: http://www.cpearson.com/excel/cells.htm