+ Reply to Thread
Results 1 to 3 of 3

Filter with a variable and select sheet with a variable not working

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    15

    Filter with a variable and select sheet with a variable not working

    Please help, I have a list of id's that I've used to create new sheets in my file and now I want to go to the sheet where the data is ("Worksheet"), filter the data by a variable ("sName"), and go to the sheet with the same name ("sName") and paste the data. Here's my code...
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    08-08-2013
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Filter with a variable and select sheet with a variable not working

    Nevermind, it was a stupid mistake. I can't figure out how to take down the thread.

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Filter with a variable and select sheet with a variable not working

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. [SOLVED] correctly 'wording' a for/next loop using a variable counter and variable filter
    By DBoyd121 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2016, 06:13 PM
  2. Dim Sheet as Variable and Select
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2013, 07:30 PM
  3. Replies: 1
    Last Post: 10-27-2012, 02:54 AM
  4. [SOLVED] Add New Sheet With Variable as Name then Select Sheet - Type Mismatch
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-07-2012, 10:41 AM
  5. Sheet is variable... - formula not working
    By madars in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2011, 06:39 AM
  6. nSheet variable to select the sheet
    By mcgrad in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-01-2008, 08:15 AM
  7. [SOLVED] Select Sheet - Variable
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2005, 08:00 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