Excel macro for printing multiple sheets...

Hi!

Let's say I have a workbook containing of 10 sheets. I would like to create a macro that would allow me to do the following:

Print sheet 1, 3 and 7. Always print sheet 1, however only print sheet 3 and 7 if there in these sheets are values in the cells from row 8 and below.

(If that is to complicated it would be ok if the condition for printing sheet 3 and 7 is that there's a value in e.g. cell A8.)

I managed to create this script that allows me to print sheets 1, 3 and 7, however I can't seem to find out where to put the if-statement (I suppose that's how you do it?). Here's the script i created so far:

Please Login or Register  to view this content.

I would really appriciate advice from you guys (and girls)

Thank you!

Kind regards,

Nicklas

Do an Advanced Search on my name with Print as the key word and you should find an example that should help

Try hiding the sheets you do not want printed, then print the entire workbook
example code

Please Login or Register  to view this content.

Try this, note chane PrintPreview to Printout when you have finished testing.

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Thanks for letting me know. Glad it helped.

The line means if the Worksheets range A9 currentregion (see below) cells count is greater than 1 then worksheet print preview

Currentregion
(The current region is a range bounded by any combination of blank rows and blank columns)

HTH

VBA Noob

Empty cells are empty. Cells with links containing formulas are not empty, therefore they are part of the CurrentRegion. You would need to check for zero values, maybe

Please Login or Register  to view this content.