How to display address of active cell in another cell

[deb45]

Hello,

I want to display active cell address in another cell. Is it possible using formula?


Regards
Deb

 

[herofox]

hi----you can to move this share to Vba Dep.
You can to Use this code in the page's Code
any Active Cell Will shown in cell A1

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

 

[deb45]

Thanks

 

[salim hasan]

try this formula in any (cell A1 for example)
when you change the value of any cell ,the cell A1 display the address

=CELL("address")