Excel - Cell

1 - 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.

3 - Get

3.1 - Range

See range

3.2 - 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)"

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap