Be the first user to complete this post
|
Add to List |
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 2nd row and in 3rd 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 18th rows and 31st 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:
- VBA-Excel: Date-Time Functions – IsDate()
- VBA-Excel: Create Array using Array() Function
- VBA Excel – Looping Through a Range of Cells
- VBA-Excel: Fill Excel Range Values in a 2D Array
- VBA-Excel: Cells Ranges Offset - Active Cell