Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change() and Range question
If someone highlights a block of cells and presses "delete"
to delete all the data in those cells, Excel will pass all those changed cell addresses to "Worksheet_Change()" into the "Target" variable. My question is, how do I enumerate through all the cells contained in the "Target" range variable?? The "Target" variable seems to contain a single string of all the cell addresses that were changed, and I'm looking for an easy way to extract each cell address from the "Target" variable. I initially thought I could use the following code, but I was wrong: Public Sub Worksheet_Change (ByVal Target as Range) for i = 1 to Target.Count nextAddress = Target(i).Address(0,0) ' Get next changed address?? Next i End Sub Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Change() and range question | Excel Programming | |||
Worksheet_change question | Excel Programming | |||
worksheet_change question | Excel Programming | |||
Excel VBA .... Worksheet_Change(ByVal Target As Range) question | Excel Programming | |||
Worksheet_Change event question | Excel Programming |