Advanced filter overrides cell formats in extract range

  • Thread starter Thread starter Joe
  • Start date Start date
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?
 
Perhaps you could filter to a temporary storage area, then copy that data.
Go to the final destination and paste as values.
 
Back
Top