VBA – Get the Active Cell’s Column or Row
In this Article
If you need to get the active cell’s column or row from VBA, use this code:
Active Cell Column
For the cell’s column:
|
1 2 3 |
Public Sub ActiveColumn() MsgBox ActiveCell.Column End Sub |
Active Cell Row
For the cell’s row:
|
1 2 3 |
Public Sub ActiveRow() MsgBox ActiveCell.Row End Sub |
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!
Did you find this VBA tutorial useful? Then share it with your friends and colleagues:
You may also like some of this related content...
Ads