Up until now I have been using Windows NT4 & Excel97. I have a workboo
with various macros to print out different reports from selected range
on spreadsheets using for example:
Range("B2:X26").Select
Selection.PrintOut Copies:=1, Collate:=True
This works fine and takes about 3 seconds before the Printer (H
Laserjet 1100) is activated.
We are changing to XP Prof and Excel2003. I have tried the same macro
with XP/2003 and there is now a 40+ second delay after eac
Selection.PrintOut line.
Does anyone have any idea why this should be, and any suggestions fo
fixing it.
Many thanks in advance,
Pau
--
Paul
-----------------------------------------------------------------------
PaulC's Profile:
http://www.excelforum.com/member.php...nfo&userid=756
View this thread:
http://www.excelforum.com/showthread.php?threadid=26158