Cells.Clear
Try
Sheets("Sheet1").Range("A1:B20").ClearContents
Mike
On Mar 1, 6:44*am, Abdul wrote:
Hi,
Worksheets("Sheet1").Cells.Clear
will clear the sheet.
If there a way that we can clear Cells less defined range?
some thing like Cells excluding "MyRange" .clear? so that t will be so
fast and without using loop
thanks
|