Thread: Cells.Clear
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
 
Posts: 39
Default 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