I would like to get cell's value [like using i.e cells(x,y).value]
from the rows which are visible after autofiltering. How to get only
these visible values?
For example:
If I have 10 rows but only 2 rows matching the autofilter criteria.

For i=1 to 10
Msgbox Range.Cells(i, 1).value
Next i

This code gives me all the values - it don't considering to autofiler
results...