Rayne
asked on
Sheet Cleaning (Not Detergents)
Hello Experts,
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.
UsedRange.clearcontents
or
currentregion.clearcontent s?
What is better way to clear content the entire sheet?
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.
UsedRange.clearcontents
or
currentregion.clearcontent
What is better way to clear content the entire sheet?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome Rayne.
Zorvek - thanks for that. I didn't know that limit until today - another learning experience!
Zorvek - thanks for that. I didn't know that limit until today - another learning experience!
ASKER
With so many options to choose from....
Hail the Great EE!!