+ Reply to Thread
Results 1 to 1 of 1

Looping through a variable with macro and autofilter

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    16

    Looping through a variable with macro and autofilter

    I am mediocre when it comes to macros. I have a worksheet named Select and it has several data validation lists in it. Another worksheet called Billings Data has autofilters. I want to run through the options in the data valdation lists and then turn several autofilters if the data validation list is not "All". I have tried several different ways and I have not been successful. The if statement doesn't seem to recognize the <>"All" and I want it to run through and check all statements below. Skipping to the next statement if "All" is in the data validation lists on the Select worksheet (below).

    Geo Consol Country Country Product Market Product Type Product Family
    Americas ALL ALL ALL ALL ALL


    Macro

    Please Login or Register  to view this content.
    Any help would be greatly appreciated.
    Last edited by JBeaucaire; 11-20-2013 at 07:50 PM. Reason: Added CODE tags around vba as per Forum Rules, please read the rules, link in menu bar above.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofilter Macro Failing because object variable not set
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2016, 02:54 AM
  2. [SOLVED] I have macro for autofilter i need suprate sheet for ever variable
    By harishb63 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-28-2013, 03:23 AM
  3. How can I add a 3rd AutoFilter Variable in a Macro?
    By jlax34 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 09:09 AM
  4. [SOLVED] autofilter macro using variable
    By 86gts in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2012, 09:51 AM
  5. looping and subtotals to AutoFilter macro
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 05:04 AM

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