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,708
    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 5 users browsing this thread. (0 members and 5 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