How to keep only the filtered results

[jardenp]

Most of my VBA scripts are modified results of the macro recorder, so I often use inelegant workarounds, though I suspect there are better solutions out there. One such workaround is how to keep only the results of a filter. I currently apply the filter, select all cells, add a sheet, and paste. This gets rid of the rows "hidden" by the filter, but if I have many filters to use throughout a macro, I'll end up with 8-10 sheets, which I delete at the end of the macro. In short, it works, but it's ugly.

Is there an easy way to keep only filter results? I'm interested in VBA code and how to do this in normal, front-end Excel use.

Thanks.

 

[jardenp]

Shameless bump. Please?