How can I extract cells address in OnCahnge event
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. |
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. . |
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. |
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com