How can I extract cells address in OnCahnge event

  • Thread starter Thread starter Guy
  • Start date Start date
G

Guy

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.
 
Hello
If Target.Cells.Count > 1 Then
MsgBox Target.Cells.Address
End If
HTH
Cordially
Pascal
 
Back
Top