Hi,

I have a worksheet with a list of approx. 1,000 rows and 16 columns.

A macro is used to run some fairly complex code to arrange the list in
different ways.

This works fine and takes almost no time.

I also have code that sets the print area, depending on the list
arrangement, and then prints.

This works OK.

The problem is that once the print code has been run it takes ages - enough
time to take the dog for a walk - for the list handling code to run.

Any ideas ?

Don