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
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
Last edited by farrukh; 01-09-2012 at 10:52 AM.
try this and tell is it ok?
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
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
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
HI Tom,
Thanks you exactly i need of it .
Bundle of Thanks
FR
Hi tom,
How can i modify this code for specific column of used range ?
Thanks
FRH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks