is there any event like worhsheet_change for ranges?

A

Abhinav

Hi,

Just wanted to know wether there is anything like worksheet_change at a
range/cell level.

What I want to do is trigger some code for a specific set of cells ,some
for a specific set of rows, some for a specific set of columns, etc ..

Adding it ALL to worksheet_change will make it sloppy ...

Thanks
Abhinav
 
F

Frank Kabel

Hi
you have to use the worksheet_change event (there's no
cell_change_event). Within the worksheet_change event you
can test the target range object and check which action to
execute
 
A

Abhinav

Frank said:
Hi
you have to use the worksheet_change event (there's no
cell_change_event).
Click to expand...

Just what i was afraid of :(

Within the worksheet_change event you
can test the target range object and check which action to
execute
Click to expand...
If this is the only way to do it, doesnt it potentially make the
worksheet_change event a big module with lots of ifs and cases .. or am
i missing something ?

Just wanted to be sure that there is no shortcut/workaround to using
this .. as this seems a bit complex...

Thanks
Abhinav
 
F

Frank Kabel

[...]
Just wanted to be sure that there is no
shortcut/workaround to using
this .. as this seems a bit complex...
Click to expand...

Hi
shouldn't be that complex. Use Intersect and/or select
case target.address
for this
 
Top