Hi,
You could use VBA to temporarily take off the filter, copy and paste your range and then re-apply the filter. If you do this after an Application.ScreenUpdating = False you wouldn't notice.

HTH