Excel 2007: Within a Macro I did the following: 1: an autofilter on a specific column w/specific criteria Question/Request: I want to do a do loop starting with the 1st row of the filter and ending with the last row of the filter.
Example:
'Set Filter
Range("AF1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$1X$44489").AutoFilter Field:=32, Criteria1:="=*GID*"
'At this point I want the row count of the FILTERED rows only.
Example of data: There are 20 rows in spreadsheet. Then autofilter is applied. Rows: 5, 6, 9, 12 and 15 are displayed with the filter. In the Do While loop, I want to process only rows 5, 6, 9, 12 & 15. I do not want the Do While loop to process rows 1, 2, 3, 4, 7, 8, 10, 11, 13, 14, 16-20.
Thanks in advance for the help.