Need formula for Selected Cell Number

[faraz502]

how to know selected cell number need a formula.

 

[GraH]

You might want to elaborate on this. Your question is too vague.
You know when you need a formula in a cell, no?

 

[faraz502]

thanks for the reply
i need when i click or scroll every where in sheet so in cell a1 give me row number.

 

[Peter_SSs]

i need when i click or scroll every where in sheet so in cell a1 give me row number.

You can't do that with a standard worksheet formula but you could do it with vba with this worksheet selection_change code.
To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window & test.
4. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm).

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

 

[faraz502]

You can't do that with a standard worksheet formula but you could do it with vba with this worksheet selection_change code.
To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window & test.
4. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm).

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

Thank a billion.

 

[Peter_SSs]

Thank a billion.

You're welcome. Thanks for the follow-up.