Perhaps you could filter to a temporary storage area, then copy that data.
Go to the final destination and paste as values.

Joe wrote:
I am using advanced filter in macros and the filter keeps changing the
formats of the cells in the extract range.

How do I keep the cell formats the same?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com