View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default How can I extract cells address in OnCahnge event

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