Clear a full Worksheet in Excel

[lb1]

I would like to clear all the cells from a worksheet. Is there a command to do this or do I need to use a range?
Thanks in advance

 

[oferprat]

Hello!

Will ActiveSheet.Cells.Clear do it for you?

Ofer

 

[lb1]

It works if I am in the specific sheet, but if I set the sheet as follows:
Set res = Sheets("2&quot
ActiveSheet.Cells.Clear
it will not work.
Any idea why?

 

[acron]

Use res.Clear or if you want to retain formatting use res.ClearContents.

Sheets("2&quot refers to a sheet named 2 (not the second sheets in the sheets collection. If youe working with the second sheet use Sheets(2), or better still use the actual name of the sheet, just in case the sheets get re-ordered.

A.C.

 

[SkipVought]

lb1,

You can use ANY worksheet Object with the Clear method. Does not need to be the ActiveSheet...

AnySheetObject.Clear

faq707-4105 How Can I Make My Code Run Faster?



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com