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:
I would really appriciate advice from you guys (and girls)
Thank you!
Kind regards,
Nicklas
Bookmarks