+ Reply to Thread
Results 1 to 2 of 2

how to delete faster in macro

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    Singapore
    MS-Off Ver
    2002
    Posts
    71

    how to delete faster in macro

    hi all, I have a macro to delete away the content of the worksheets
    Please Login or Register  to view this content.
    this code is only for one sheet, I have repeated this code for all the sheets I have, it takes a long time to run it as I have about 20 worksheets.
    Any way to improve the process? does delete of the cells will be faster?
    how can i change the code to delete instead of clear the content.

    I would like to have a macro to delete the cells from row 2 to the last available row and from column A to Column P. After delete, it will shift the cell up.
    any one can help to amend my coding ?

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: how to delete faster in macro

    this should do it:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1