if find blank in specfic ranges then blank the specfic range cells

[farrukh]

Hi All,


I need that if find blanks cells (for specific range suppose A10 to G30 ) then blank the cells range
( T20 to AZ 50) I need it for many ranges ?


Thanks
Hammeed

[tom1977]

try this and tell is it ok?

Please Login or Register  to view this content.

[Richard Buttrey]

Do you literally mean that if any of the A10:G30 cells are blank you want T20:AZ50 to also be blank? Which would imply only needing to find one blank cell, clear the contents of T20:AZ50 and then stop.

Or is there some sort of more meaningful connection between the A10:G30 cells and the T20:AZ50 cells
If so perhaps give us a specific example workbook with a before and after position.

Regards

[farrukh]

HI Tom,

Thanks you exactly i need of it .


Bundle of Thanks
FR

[farrukh]

Hi tom,

How can i modify this code for specific column of used range ?

Thanks
FRH