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 ?
0
give a positive ratinggive a negative rating
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
Share on FacebookShare on TwitterShare on LinkedInSend email
1 answer
x
x
2025 AnswerTabsTermsContact us