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...