I currently have a spreadsheet that I run a macro on to save the sheet and print 2 copies out. This works OK.
In some cases I now need to output as a PDF and print 1 copy.
I have found the relevant code for swapping the active printer to my PDF printer and back, however, what I would like is one print button that knows whether I require 2 printed copies or 1 PDF+1 print.
I have put a vlookup on my sheet to find and show this setting in cell L2; so basically I want the macro to run
IF L2 <> PDF then print 2 copies ELSE print 1 to pdfprinter and 1 to printer.
How do I build this IF statement into my current code?
Thanks
Bookmarks