MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clear the Content


Posted by Mick on November 19, 2001 8:07 AM

I want to clear the worksheet content before I call the macros that read the refreshed data from input files. how to do that?

Thanks.


Posted by Catherine Munro on November 19, 2001 10:00 AM

Add a line to the beginning of the macro --

Worksheets("Sheet1").Range("A1:A10").ClearContents

Posted by Craig on November 19, 2001 11:31 AM

Or to clear the entire sheet;

Sheets("Sheet1").Select
Cells.Select
Selection.ClearContents