Print multiple sheets

R

RI

Hi,

I am trying to print multiple worksheets from a VBA-macro:
Application.Worksheets(Sheets).Select
Application.Dialogs(xlDialogPrint).Show

In the printer dialog, we select a tray from the printer. The problem is
that only the first sheet is printing from the selected tray. The other
worksheets are using the default printersettings, the wrong tray ;-(

Does anyone know a solution?

Thanx
R.I.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top