After applying auto filter, I want to perform process on visible rows using code below. Can some one please tell me
1 - how to find out how many rows after the filter ?
2 - how to move foreward to NEXT ROW instead of next cell on the same row ?
Selection.AutoFilter Field:=3, Criterial:=UserSpecified_Criteria1
Selection.AutoFilter Field:=5, Criterial:=UserSpecified_Criteria2
Range("A2").CurrentRegion.SpecialCells(xlVisible).Select
For Each C In Selection.SpecialCells(xlVisible)
Perform my processing on this row of data
What instruction here to forward to NEXT ROW ?
Next
Thanks in advance for any advise
Bookmarks