How to get the position (row number and column number) of all cells selected by mouse in Excel

fenlie123

How to get the position (row number and column number) of all cells selected by mouse in Excel

andyji

Add the following code to the required sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Target.Offset(0, 0) = Target.Row&","&Target.Column
   
End Sub

The result is that the row number, column number are automatically entered in the corresponding cell

andyji

As long as the mouse clicks on a cell, the row number and column number can be automatically obtained. Is such a result needed?

星空再现

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim Rng As Range
    For Each Rng In Target
        MsgBox "Row:"&Rng.Row&";Col:"&Rng.Column
    Next
End Sub

andyji

Master, mine is only suitable for single selection of a certain cell, yours can be selected in pieces, great. . .