delete cells depends on another values

Posted by Buto Besar on December 30, 2001 7:13 PM

let say i have data in cell b1 and b2(peoples name )..
what i like to do is if i delete the data in cell b1 and b2,
all their details (d1:d2 , f1:f2 , h1:h2 , j1:j2 )
will also deleted..thanks

Posted by Jacob on December 31, 2001 4:53 AM

This might work

sub worksheet_change

if target.column = 2 and target.value = "" then
range("D1:J2").select
selection.clearcontents
else
end if

Jacob