VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations

In the earlier tutorial (Range), you have seen how you use Range property. In this tutorial you will see the many different ways to use Range property to refer the excel sheet’s rows and columns.

Reference - Range (“A1”)

-          Refer Cell A1

Reference – Range (“A1:D10”)

-          Refer all the cells from A1 to D10 ( The entire MxN matrix)

Reference – Range(“A1:C3”,”D5:H7”)

-          Refer all the cells from A1 to C3 and D5 to H7

Reference – Range(“A:A”)

-          Entire Column A

Reference – Range(“A:F”)

-          Columns from A to F

Reference – Range(“A:A”,”M:M”)

-          Columns A and M

Similarly you can write the reference for rows

Reference – Range(“2:2”)

-          Entire Row 2

Reference- Range(“2:5”)

-          All the rows from 2 to 5

Reference – Range (“3:3”,”5:5”)

-          Rows 3 and 5

Also Read:

1. VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()
2. VBA-Excel: Date-Time Functions – Month(), Year() and MonthName()
3. VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers
4. Excel-VBA : Prevent Changing the WorkSheet Name
5. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
6. VBA-Excel: String Functions – strComp()
7. VBA-Excel: Copy/Paste data - Copy the Entire row data and paste it to another row
8. VBA-Excel : Strings Functions – Right