About
In Microsoft Excel, you usually select a cell (see active cell) or cells and then perform an action, such as formatting the cells or entering values in them. In Visual Basic, it is usually not necessary to select cells before modifying them.
Articles Related
Get
Range
See range
Cells
Use Cells(row, column) where row is the row index and column is the column index, to return a single cell.
'Cell A1
Worksheets(1).Cells(1, 1).Value = 24
'Cell A2
ActiveSheet.Cells(2, 1).Formula = "=Sum(B1:B5)"