We only have 1 A3 printer, which is not the default for all the pc's.
However I found a way round this problem, I let the user choose th
printer from the list of available ones by adding one line above m
code.

Application.Dialogs(xlDialogPrint).Show

All's good now & it's home time!! Excellent stuff

Take care
CA

--
Message posted from http://www.ExcelForum.com