There are several objects in Excel:
application, workbook, worksheet, range, cells.

Application: It is Excel itself.
Workbook: The excel file (but may contain several worksheets)
Worksheet: A single table, worksheet.
You can use worksheets("sheetName") or worksheet(index) to get it.

Range: An area in your worksheet. you can get one whole area or serveral separate area.

like: Range("A1:C3") means:

Range("A1:B2","C4:D5")means:

Cells:

Cells(rowIndex,columIndex) :

1.It is start from 1.

2.row number first, column number second.

Selection:

use dot syntax to select the object.

like Range("A1:B2").Select

Offset:

To move one cell down (from B2 to B3): Range("B2").Offset(1,0).Select
To move one cell up  (from B2 to B1): Range("B2").Offset(-1,0).Select