I have a macro which produces a report over a number of worksheets. The macro then sets each page up to be printable (sets print area etc), but, when I try to print the entire workbook it crashes. On NT this means a Dr Watson error and on XP I get excel has performed an illegal operation... I've searched a number of forums for the answer, other people seem to have experienced similar problems but no solutios have been identified? Anyone help?

Thanks a lot!