Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to locate the Row and Column of an Active Cell
Hello,
Does anybody know how to display the Row and Column of an Active Cell and display it in another cell. Regards, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to locate the Row and Column of an Active Cell
Hi Fred
Copy this event in the sheet module Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").Value = Cells(Target.Row, Target.Column).Address(False, False) End Sub In A1 you see the address now -- Regards Ron de Bruin http://www.rondebruin.nl "Fred" wrote in message ... Hello, Does anybody know how to display the Row and Column of an Active Cell and display it in another cell. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|