Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

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.clearcontents?

What is better way to clear content the entire sheet?
SOLUTION
Avatar of Elton Pascua
Elton Pascua
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

You guys are awesome
With so many options to choose from....
Hail the Great EE!!
You're welcome Rayne.

Zorvek - thanks for that. I didn't know that limit until today - another learning experience!