how to erase the full content of a sheet
 

Hi,

I would like to know how can i erase the content of all cells from a sheet.

i tried somethine like sheet(1).range("A1:IV65536").value=""
but it use 100 % CPU for 20 seconds and more than 180 Mb of memory...

i'm sure that something else can be done easily and without such resource
usage.

Maileen

how to erase the full content of a sheet
 

Maileen,

Sheet(1).Clear - to clear all
Sheet(1).ClearContents - to preserve formatting.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Maileen" wrote:

Hi,

I would like to know how can i erase the content of all cells from a sheet.

i tried somethine like sheet(1).range("A1:IV65536").value=""
but it use 100 % CPU for 20 seconds and more than 180 Mb of memory...

i'm sure that something else can be done easily and without such resource
usage.

Maileen

how to erase the full content of a sheet
 

Hi Maileen,

Try:

Sheets(1).Cells.Clear


---
Regards,
Norman



"Maileen" wrote in message
...
Hi,

I would like to know how can i erase the content of all cells from a
sheet.

i tried somethine like sheet(1).range("A1:IV65536").value=""
but it use 100 % CPU for 20 seconds and more than 180 Mb of memory...

i'm sure that something else can be done easily and without such resource
usage.

Maileen