How to get the cell row and column number from Range - excel VBA
Hi,
How can I get the cell row number and cell column number from Range function in excel macro using a VBA ?
To get the cell row and column number from Range, use .Row and .Column functions.
In this example, you can get the position of active cell (because ActiveCell returns a Range object):
Dim CellPositionRow As String
Dim CellPositionColumn As String
CellPositionRow = ActiveCell.Row
CellPositionColumn = ActiveCell.Column
1 answer