Return row number of selected cell

[zanguard80]

Hello, could somebody post a script that inputs the row number of the selected cell in cell F7 please? For example, if cell G5 is the active cell, cell F7 would read '5'; if W10 is the active cell, cell F7 would read '10', and so on.

Thanks in advance!

[protonLeah]

Range("D7").Value=ActiveCell.Row

[zanguard80]

Range("D7").Value=ActiveCell.Row

Thanks, it works, but it isn't updating automatically when I click on different cells in the sheet. What needs to be added?

Edit: Never mind—I figured it out.

Please Login or Register  to view this content.