VBA for print if cell contains, then choose printer. Have code just need advice.

Untested, but maybe:

Please Login or Register  to view this content.

This works perfectly for print!

Is there a way to make it print out straight after Application.Dialogs(xlDialogPrinterSetup).Show?

My version pops the dialog box first, then does the printouts automatically.

I fear you are not reading these macros carefully and absorbing what they are doing and when/how. The .Show is a single line of code, certainly you can see in my macro where that occurs, and then where my macro prints the jobs one sheet at a time.

Certainly you can see in the other macro where those codes are and move them appropriately? This is hard to read at first, but you can do it. Post up your working successful macro, or post what you've tried if it fails.

Originally Posted by JBeaucaire

I fear you are not reading these macros carefully and absorbing what they are doing and when/how.

Fair comment!

I tried:

Please Login or Register  to view this content.

I am still very new to VB (one week!), I'm stuggling to identify what line of code in vfxd's groups it into one print job?

You're trying to use My macro to do what his does. Mine doesn't do that. Mine is a good example of doing the dialog show first, which you seem to have gotten.

Now, I would say you use the rest of his macro, not mine. Plus, I see there is a new line of code needed, his code "selects" all the sheets, the added line now prints them all at once with the printer you've already selected:

Please Login or Register  to view this content.