Hi Bob,
What if the selection is done from bottom up and/or right to left ? :-)
Actually the original code should work with multiple selection :-))) LOL
Regards,
KL
"Bob Phillips" wrote in message
...
That is the selection address. If he really means activecell address, he
needs
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("a1").Value = Target(1, 1).Address
End Sub
--
HTH
Bob Phillips
"KL" wrote in message
...
Hi,
Try this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("a1").Value = Target.Address
End Sub
Regards,
KL
"Bond S.C" <daumbond at wrote in message
...
Hi, everybody
I can get the activecell address. using below code.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("a1").Value = ActiveCell.Address
End Sub
But, if I select multi cells (ex : range("b1:f:20")
I can't get activecell.address.
Please let' me know how to get the activecell address in this case.
Bond! <Chon, Sung-Chul