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.

Hi
try
dim cell
for each cell in target
msgbox cell.address
next

-----Original Message-----
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

"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.