how to erase the full content of a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy content of 1 sheet to another one. 1
Rename sheet with content in specific cell 4
Copy content of 1 sheet to another one 2
Create a Macro to Range Cells, from the contents of another Cell. 1
Scroll to Top of Sheet, When Sheet is FIRST Activated 3
How to clear contents of multiple cells in Excel simultaneously 1
How do I retrieve the contents of a Cell from different sheets? 4
how to flip contents inside the cell of an excel? 2

Back
Top