Late thought: perhaps if your printer setup has an option to print separator
pages or not, you could use File | Print and then inhibit the printing of
separator pages for the job? That would be so much easier than building the
code I alluded to earlier.


"Stup88" wrote:

When we print multiple copies of a excel worksheet say 5, we get instead of
one seperator page we get 5. Is there a way to get excel print it as one job,
it appears it is doing 5 sepearte jobs to print the 5 copies.

Any thoughts ?

Thanks