To select a cell in Excel, you have two basic methods: RANGE and CELLS:
Range ("A1").Select
Range("RangeName").Select
Cells(3, 4).Select 'Selects Row 3, Column 4, i.e. cell D3
Range works well for hard-coded cells. Cells works best with calculated cells, especially when you couple it with a loop:
For i = 1 to 10
Cells(i, 1).value = i ' fill A1 through A10 with the value of i
Next i
Note that your focus does not change. Whatever cell you were in when you entered the loop is where you are when you leave the loop. This is way faster than selecting the cell, changing the value, selecting the next cell, etc. If you are watching the sheet, the values simply appear.
One of the techniques I have found very useful in writing Excel VBA code is to make the cell, row, and column references public constants rather than hard coding them.
Take a reference to a row and column:
cells(4,27).value
If row 4 is the first data row and column 27 is the last column in the list, it is more useful to make them constants and refer to the constant:
Public Const intFirstDataRow As Integer = 4
Public Const intLastRow As Integer = 27
And then make the above reference:
cells(intFirstDataRow, intLastRow).value
This way, when you add a couple of columns or move the first data row down, you change the constant once and the code all works the first time.
Searching and replacing 27 with 31 is fraught with problems since it is too easy to change values or longer numbers (12734 to 13134) inadvertently.