View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bond S.C Bond S.C is offline
external usenet poster
 
Posts: 2
Default How can i get activecell address

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