If true is found then clear the content of that complete sheet

  • If true is found in any cell, anywhere in a sheet then clear the content of that sheet completely means clear all the data in that sheet, make a sheet blank


  • Note: I used selected range instead of entire range of the cell because it will take long time to finish the command.


    Hope it helps (i did not test it).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!