Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Excel VBA - clear the contents of an entire sheet.

  1. #1
    Join Date
    5th August 2004
    Posts
    30

    Excel VBA - clear the contents of an entire sheet.

    How to clear the contents of an entire sheet.

    i want to delete the contents of the sheet1. without deleting the sheet.

    Excel Video Tutorials / Excel Dashboards Reports


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

    To clear all use;

    Sheet1.Cells.Clear

    To clear only content (no formats) use;

    Sheet1.Cells.ClearContents

    To Clear only formats use;

    Sheet1.Cells.ClearFormats

    To clear only cell comments use

    Sheet1.Cells.ClearComments

    Then there is also;

    Sheet1.Cells.ClearNotes

    and

    Sheet1.Cells.ClearOutline

  3. #3
    Join Date
    13th June 2012
    Posts
    1

    Re: Excel VBA - clear the contents of an entire sheet.

    Dear Dave,

    This is a thoroughly helpful response. Not only do you susinctly answer the question, you explain a couple of useful other option. If only the internet was always so well considered....

    Thank you.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Clear Contents Macro
    By kfotedar in forum EXCEL HELP
    Replies: 7
    Last Post: July 19th, 2006, 05:23
  2. Clear Contents??
    By Sirius Black in forum Excel and/or Powerpoint Help
    Replies: 4
    Last Post: June 20th, 2006, 22:21
  3. Replies: 3
    Last Post: October 23rd, 2005, 09:00
  4. Replies: 4
    Last Post: July 21st, 2004, 05:38

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