ExcelBanter - How to display current row number in fixed cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to display current row number in fixed cell? (https://www.excelbanter.com/excel-programming/336898-how-display-current-row-number-fixed-cell.html)

OldBoy

How to display current row number in fixed cell?

(New VBA-user!)
I want to have the current row number displayed in a fixed cell.
Could you please give me a hint?

OldBoy

Jim May

How to display current row number in fixed cell?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("D1").Value = ActiveCell.Row
End Sub

"OldBoy" wrote in message
. ..
(New VBA-user!)
I want to have the current row number displayed in a fixed cell.
Could you please give me a hint?

OldBoy

OldBoy

How to display current row number in fixed cell?

Great!
Thanks a lot.

OldBoy

"Jim May" wrote in message
news:gamKe.16296$MZ6.9262@lakeread01...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("D1").Value = ActiveCell.Row
End Sub

"OldBoy" wrote in message
. ..
(New VBA-user!)
I want to have the current row number displayed in a fixed cell.
Could you please give me a hint?

OldBoy

OldBoy

How to display current row number in fixed cell?

Found also this one:

=cell("row")

OldBoy

"Jim May" wrote in message
news:gamKe.16296$MZ6.9262@lakeread01...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("D1").Value = ActiveCell.Row
End Sub

"OldBoy" wrote in message
. ..
(New VBA-user!)
I want to have the current row number displayed in a fixed cell.
Could you please give me a hint?

OldBoy

All times are GMT +1. The time now is 02:42 PM.