+ Reply to Thread
Results 1 to 3 of 3

Add Auto Filtered Non Contigous range to Array

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007; Excel 2010
    Posts
    178

    Add Auto Filtered Non Contigous range to Array

    Hi,

    Can anybody tell me how to add a Auto Filtered non contigous range to an array

    This is what I use but does not go beyond 1st occurence of filtered values, meaning the code below will not add non contiguos ranges

    Please Login or Register  to view this content.
    Thanks

    Lionel
    Last edited by Foreverlearning; 06-29-2012 at 06:25 PM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add Auto Filtered Non Contigous range to Array

    Hi Lionel
    This option does not work
    Please Login or Register  to view this content.
    Try something like
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007; Excel 2010
    Posts
    178

    Re: Add Auto Filtered Non Contigous range to Array

    Hi nilem,

    Thanks for reply will try out tommorrow and let you know.

    Thanks
    Lionel

+ 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