Advanced filter overrides cell formats in extract range

J

Joe

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?
 
D

Debra Dalgleish

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