VBA for Printing with If statements

[Capergirl]

I am wondering how to create a VBA print function that will allow

• print from multiple sheets
• Print related information only if required.

Input screen has five options that are not always going to be required on printed document and one option may allow it to be up picked six times. User identifies what is required and I want to print the information for selected options on one printed document with no extra white space.

The input screens concatenate information and display each options results on its own worksheet all in the same workbook.

Hope this makes sense and thanks for any direction you can provide.

 

[Ron de Bruin]

mmmm, you are not very clear what you want so I suggest to check out the print section with vba examples on this page and get back if you need help. Other Topics