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

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

Hi Maileen,

Try:

Sheets(1).Cells.Clear


---
Regards,
Norman



"Maileen" <Maileen@discussions.microsoft.com> wrote in message
news:6A25A520-9160-4507-B59B-E5B1C483762D@microsoft.com...
> 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