|This code will return the Row and Column numbers of the cell you select. Click on the sheet tab for the sheet you will be selecting a cell in, choose View Code, and paste the code into the pane that opens.|
I'm not sure what you want to do with that information, so the code will do 2 things:
1 - Place a formula in Sheet2!A1 to retrieve the contents of that cell based on the Row and Column numbers.
2 - Place the contents of the selected cell directly into Sheet2!A2 without using a formula.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Build formula for Sheet2!A1 using Row & Column numbers
Sheets(2).Range("A1").FormulaR1C1 = _
"=" & Sheets(1).Name & "!R" & Target.Row & "C" & Target.Column
'Place contents of selected cell directly in Sheet2!A2
Sheets(2).Range("A2") = Sheets(1).Range(Target.Address)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.