Morning KL,

You are right, it should be Activecell.Address.

Bob

"KL" wrote in message
...
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