I am dealing with a unusual situation. I have a sheet that might data in some corner of the sheets like some data on A1, some on B1:B100 and random cell ranges. what is the ultimate way to clean the worksheet sheet1 of this mess.
I have aprocess module that has to work on the sheet but before it works, I need to cleanse sheet1 of this random data mess.
What is better way to clear content the entire sheet?