View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
papou[_10_] papou[_10_] is offline
external usenet poster
 
Posts: 27
Default How can I extract cells address in OnCahnge event

Hello
If Target.Cells.Count 1 Then
MsgBox Target.Cells.Address
End If
HTH
Cordially
Pascal

"Guy" a écrit dans le message de
om...
Hi,

I'm trying to extract the cells address for more then one cell in OnChange

event.

I can use the Target.Address property if only one cell is changed,
How i get the address for each cell in case i have more the one?

Thanks,
Guy.