Hi All

I have a macro that formats raw data to make it look like an old
legacy report for some people who refuse to move with the times! :)
This results in adding extra blank rows in the data. When my default
printer is set to my network printer the macro runs very slow. When I
change the default printer to the image writer the code runs quicker:

Application.ActivePrinter = "Microsoft Office Document Image Writer on
Ne00:"

I am not really happy with this solution though as I sure this fix
wont work on someones machine somewhere. It seems like a hack rather
than a neat solution.

Additionaly to set back to the network printer takes 12 seconds!

Is there a better solution where I dont mess with the users default
printer? I have tried clearing the print area before the macro runs
and also setting the print area to a single cell. No luck.

Cheers for any thoughts
Chrisso