VBA Excel - Cells, Ranges and Offset : Cells

Format : Cells(Row,Column)

Excel is represented in a grid format, tabular form in rows and columns, so to reach to particular cell you need tell to compiler the cell is located in which row and which column in that particular row.

Ex: in VBA Excel when you say Cells(2,3) which means, in 2^nd row and in 3^rd column means “C2”

Some of the very effective functions of Cells are

• Cells.Select
• Cells.ClearContents
• Cells.SpecialCells(xlCellTypeLastCell) (Ex: Delete Blank rows)

These functions are pretty much similar to other VBA Excel functions like UserRange.Clearcontents or UserRange.Select or UsedRange.Copy

To know more about UserRange Click here (VBA Excel-Range)

But while using Cells, sometimes it’s a tedious task to find out which cell you are talking about when you say suppose

Cells(18,31) which means 18^th rows and 31^st column (“AE”), rather we prefer saying it as “AE18” instead 18,31

So that’s why we have Range and it’s recommended to use Range over Cells at most of the places

Also Read:

1. VBA-Excel: Fill Excel Range Values in a 2D Array
2. VBA-Excel: Arrays – Two Dimensional, Static Array
3. VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
4. VBA-Excel: Date-Time Functions – DatePart()
5. VBA-Excel: String Functions – RTrim()