is there any event like worhsheet_change for ranges?
 

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

is there any event like worhsheet_change for ranges?
 

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

.

is there any event like worhsheet_change for ranges?
 

Frank Kabel wrote:

Hi
you have to use the worksheet_change event (there's no
cell_change_event).

Just what i was afraid of :(

Within the worksheet_change event you
can test the target range object and check which action to
execute
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

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

.

is there any event like worhsheet_change for ranges?
 

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


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