View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maileen[_3_] Maileen[_3_] is offline
external usenet poster
 
Posts: 6
Default 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