VBA Range / Cell Address
In this Article
This tutorial will demonstrate how to get a cell’s address.
Get Range Address
This will display the cell address using the Range object:
|
1 |
MsgBox Range("A1").Address |
Get Cells Address
This will display the cell address using the Cells object:
|
1 |
MsgBox Cells(1,1).Address |
ActiveCell Address
To get the ActiveCell address use this code:
|
1 |
MsgBox ActiveCell.Address |
Set Variable to Cell Address
You can also assign the cell address to a string variable for easy use within your code:
|
1 2 3 4 |
Dim strAddress As String strAddress = Range("A1").Address MsgBox strAddress |
Get Row Number From Cell Address
This code will extract the row number from an address:
|
1 2 3 4 5 6 7 8 9 10 11 |
Sub GetRowNumberFromCellAddress() Dim strAddress As String Dim rownum As Long strAddress = Range("A1:a10").Address rownum = Range(strAddress).Row MsgBox rownum End Sub |
However, usually you can use this much simpler code:
|
1 |
MsgBox Range("A1").Row |
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!
