Results 1 to 7 of 7

Code the saves filter info to reapply after running other code

Threaded View

Wedge120 Code the saves filter info to... 08-25-2011, 10:22 AM
MarvinP Re: Code the saves filter... 08-25-2011, 10:43 AM
Wedge120 Re: Code the saves filter... 08-25-2011, 12:32 PM
MarvinP Re: Code the saves filter... 08-25-2011, 01:51 PM
Wedge120 Re: Code the saves filter... 08-25-2011, 02:23 PM
MarvinP Re: Code the saves filter... 08-25-2011, 05:05 PM
Wedge120 Re: Code the saves filter... 08-25-2011, 05:49 PM
  1. #3
    Forum Contributor
    Join Date
    11-05-2006
    Posts
    123

    Re: Code the saves filter info to reapply after running other code

    In this workbook, I choose which parts I need (rows), and I place the number needed in column "R". After I enter the number needed in this column, I run a "sheetstats" macro that looks at the parts I have chosen and provides totals and other info about the parts chosen.

    Before placing these quantities in column "R", I use the autofilter to gradually pick and choose parts based on the various critieria. In order to run my "sheetstats" macro, however, the filters are cleared as this macro releases them in order to make calculations.

    I was wondering if there were a way to run the "sheetstats", but also see the filters that were used to make my choices.

    I guess and alternative way to achieve this would be to write the "sheetstats" macro in a way that doesn't require the release of the filters, but I really don't know how.
    Attached Files Attached Files
    Last edited by Wedge120; 08-25-2011 at 02:19 PM.

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