+ Reply to Thread
Results 1 to 2 of 2

Remove all filters from each sheet, then clear content?

  1. #1
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Remove all filters from each sheet, then clear content?

    Hi all,

    There has to be a better way to remove any/all filters (if any are set) and to clear all cells from worksheets than what I have below:
    Please Login or Register  to view this content.
    This is pretty basic stuff, I know, but for some reason, this periodically freezes up the application and I have to kill Excel from task manager. I have NO Idea why, or how to make it stop... so, if you have any ideas, would love to read them.

    Thanks, as always!
    Last edited by JP Romano; 09-07-2010 at 06:30 PM. Reason: resolved

  2. #2
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Remove all filters from each sheet, then clear content?

    Okay, I figured out my problem...agh...had nothing to do with this bit of code.
    Sorry!

+ 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