Glad you found the solution and glad you posted it. Now google can help the
next person.

Richard Buttrey wrote:

On Sun, 29 Jan 2006 11:01:27 -0600, Dave Peterson
wrote:

I've noticed slow downs after I do a file|print or File|PrintPreview. Those
dotted lines that show up that indicate where the new page breaks can slow down
excel.

If you're adding/deleting rows/columns, then excel figures that it should
determine where to redraw those lines.

I'm not sure if that's a good fit for the .advancedfilter stuff--but I would try
turning those dotted lines off.

__

Dave,

Thanks for the prompt response - and on a Sunday as well :-).

I don't think it was anything to do with your suggestions, but I've
filed them away for future ref. You never know.

I think I've finally tracked it down - or at least I've managed to get
it back to normal but don't really understand why.
I selectively deleted other sheets in the workbook, testing the filter
macro each time, and found that after deleting one of them, the
filtering macro worked as normal. What seems strange is that the sheet
I deleted was neither the sheet containing the data being filtered,
(obviously !) or the sheet the data was being copied to. The only
remote connection I can see is that on the sheet that received the
filtered data, (but not the area to which the data is copied), there
are formulae which refer to the deleted sheet.

The deleted sheet receives its data via an upload from another
application, so I went back to basics and reloaded that data again.

That seems to have cured the problem, but I'm really non the wiser as
to what the fundamental problem might have been.

All part of life's rich pageant as they say.

Rgds, and thanks again.
Richard Buttrey
__

--

Dave Peterson