Thread: show row number in one fixed cell in reference to your cursor pos.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default show row number in one fixed cell in reference to your cursor pos.
Right click the sheet tabView code and paste the below code in the right
code panel. Try selecting cells...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Range("A1") = Target.Row
Application.EnableEvents = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Howard" wrote:

For example,
key in this formula cell("row") in cell A1
when you move your cursor to Cell B9
cell A1 will display "9" = row 9 where ur cursor being placed at
Reply With QuoteReply With Quote