Copy result of an Autofilter to another Sheet.
Posted on 2014-02-05
ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="#N/A"
How do I copy the results of this autofilter to Sheet2?
When I go to select the first cell and ctrl+shift+down to select the range it can be different each time. A22 one time A10 another.. How do I tell it to just select the visible cells in column A, and copy them to another sheet?
If the filter does not produce any results? skip copying this to the other sheet. (there are just headers in the filter, or do not count row 1.
I need to run another procedure on the results of this filter... any ideas? -R-