Results 1 to 2 of 2

Filter - Multiple Columns - Loop through Visible Rows issue

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2016
    Posts
    110

    Filter - Multiple Columns - Loop through Visible Rows issue

    Dear all,

    Regarding Looping Visible Rows on a Filtered (Multiple Columns) data.

    Need your help in selecting the range.

    PFA.

    Debug the function AgeName_Mapping().

    I'm facing issues in looping visible rows on filtered data where filter has been applied on Multiple Columns.

           With ActiveSheet
                
                With .Range("$A$1:$D$1")
                                    
                    .AutoFilter
                    .AutoFilter Field:=rID.Column, Criteria1:=ID
                    .AutoFilter Field:=rYear.Column, Criteria1:=ID_Year
    
                End With
    
            End With
            
            'Selecting Visible Rows
            Dim rrID As Range
            Set rrID = Range("A2:A" & Range("A65536").End(xlUp).Row).SpecialCells(xlCellTypeVisible)
            
            ' I guess the above Range needs to be selected to loop through multiple Filtered Columns and not Just One.
            
            For Each i In rrID
                
                i.Select
                    
            Next
    On executing i.Select, I would like A2 to get Selected in the sheet " Mapping ".

    Please help

    Thanks,
    Vinod Krishna

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. delete all visible rows after a filter
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2013, 07:02 AM
  2. Filter rows based on cell values in multiple columns
    By dionaqld1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2012, 09:13 AM
  3. Issue moving data with multiple rows into columns
    By fguardia in forum Excel General
    Replies: 2
    Last Post: 07-30-2010, 11:53 AM
  4. Resize Visible Rows based only on Visible Columns text
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2009, 10:55 AM
  5. AutoFilter: Loop Thru Visible Rows?
    By Damian Carrillo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2005, 10:05 PM

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