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.
On executing i.Select, I would like A2 to get Selected in the sheet " Mapping ".![]()
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
Please help
Thanks,
Vinod Krishna
Bookmarks