VBA: Cell references

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!