One of the most common use object is the Range object.

Normally, to refer a cell, we simply put the cell address into the range such as Range("A1"). Now, what is the simpliest way to refer to other cell like B1?

There are many ways to use the range object to refer to the cell from your starting cell. I find the simpliest way is the following: 

For example, if I want to refer to B1, I can simply write it as such:

Range("A1")(1,2).value or range("A1")(,2).value

This will return cell B1 value.

If I want to refer to cell B2, I will write range("A1")(2,2).

This is simply an offset statement where the syntax is range()(row,column).

(1,1) refer to the start cell in the range object. In this case, it is A1. (2,2) will bring you to B2.

If you are at B2, and you type range("B2")(0,0).value , this would return the value in A1.

So, what is the point of knowing this? Well, if you are a For Loop lover like me, this will make your life sweet and easy. You could simply put your for loop counter into the row value to refer to the next row. For example,

Dim i as integer
 
For i = 1 to 2000
 
      msgbox range("A1")(i).address
 
next i

Hope this help.