Advanced filter overrides cell formats in extract range

's Computer Specifications

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?

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Advanced Filter to extract email addresses	=?Utf-8?B?RnJhbmsgV29vZA==?=	Microsoft Excel Misc	4	1st Mar 2007 10:54 PM
Advanced Filtering Extract Range Missing,etc	bridges_22	Microsoft Excel Worksheet Functions	1	6th Feb 2006 04:19 PM
advanced filter a range	=?Utf-8?B?SWwgUHJpbmNpcGU=?=	Microsoft Excel Worksheet Functions	2	1st Aug 2005 03:27 PM
missing or ill egal extract range advanced filter	=?Utf-8?B?dGp0amp0anQ=?=	Microsoft Excel Misc	3	10th Jul 2005 10:06 PM
copy results of advanced filter to a dynamic range - if only want certain records from the results - filter used to narrow down selection	Cheryl	Microsoft Excel Discussion	1	20th May 2004 02:19 AM