Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Clear All Worksheet Cells

  1. #1
    Join Date
    20th July 2007
    Posts
    41

    Clear All Worksheet Cells

    Hello again cityzens of OZGRID


    Gotta question about destroying the contense of a worksheet. If for instance I got a macro which uses a different source everytime I run it, and this macro gives a result in a result worksheet. How can I possibly delete the contense of the result worksheet automatically before the execution starts?

    What I mean is: without selecting all the cells and pressing delete or either using a for loop to go through all the worksheet cells. Is there any function which clears the contense of a worksheet? (without deleting the worksheet itself)

    Thx guys

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Clear All Worksheet Cells

    VB:
    Sheet1.UsedRange.Clear 
    
    
    Where Sheet1 is the CodeName of the Worksheet

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    20th July 2007
    Posts
    41

    Re: Clear All Worksheet Cells

    Thank you very much Dave, you allways submit useful answers

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 2
    Last Post: March 30th, 2008, 19:29
  2. Clear All Cells On Another Worksheet
    By SKeene in forum EXCEL HELP
    Replies: 3
    Last Post: February 22nd, 2008, 06:59
  3. Clear Worksheet Chosen From Drop-Down
    By Jaspa in forum EXCEL HELP
    Replies: 4
    Last Post: August 22nd, 2007, 08:11
  4. Clear Data Cells Only. Not Formula Cells
    By Malhar in forum EXCEL HELP
    Replies: 4
    Last Post: August 6th, 2006, 15:29
  5. clear contents of Worksheet
    By ParTeeGolfer in forum EXCEL HELP
    Replies: 1
    Last Post: April 2nd, 2006, 15:32

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
  •  
porno