+ Reply to Thread
Results 1 to 3 of 3

VBA - AdvancedFilter

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    VBA - AdvancedFilter

    Most likely this might seem very rudimentary to many of you VBA superstars, but thought I would share for those who still struggle with VBA, like I .

    Over the past weeks I've been using a ton of Advanced filter and today I finally got to the point where I said the magic words, time to automate.

    Anyway, nothing earth shattering, but thought I would share the macro perform advanced filter on the selected column with the results copied to the last available column + 1.

    There might be that one person who finds this useful...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: VBA - AdvancedFilter

    Good of you to bring this up Jeff because AdvancedFilter deserves more attention then it gets right now.
    It's a bit of a lost child although it's a powerful tool to create unique lists or for filtering datasets.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: VBA - AdvancedFilter

    Before I really understood Excel, I can remember taking a list from Excel, putting it in an Access table, running a query for a distinct list, then pasting it back into Excel.

    Wow, the day I learned Excel could create a unique list. Awesome

+ 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. AdvancedFilter help
    By lucianor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 10:57 AM
  2. AdvancedFilter Sub
    By RTM1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2010, 08:22 PM
  3. Help with AdvancedFilter macro
    By Mark I in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2009, 09:46 AM
  4. AdvancedFilter problem
    By JA1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2007, 04:21 AM
  5. [SOLVED] AdvancedFilter
    By dannibrook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2006, 06:25 AM
  6. Advancedfilter
    By ram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2005, 10:20 PM
  7. AdvancedFilter with VBA
    By newToExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2005, 12:20 PM
  8. AdvancedFilter in VB
    By loopy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2005, 11:05 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