Thanks for help Westconn1 but that didn't work
I still get empty pages out.
Here is attach with this workbook and can you please look at it and see whats wrong?
In this workbook I cut out 4/5 of TOC (in bouth sheets) for easyer working (somethimes is on sheet "Naslovi" one row per page somethimes are two rows per page, in original file)
Sheet pass = " " 'space
In normal work, one can edit only blue fields in sheet "Sadrzaj", edit "1" and "0" on left side, btn "Skrati", than print first sheet, than second sheet (rows "marked" with "0" in first sheet are not suposed to printout!).
btn "Skrati" - hide rows in both sheets that have "0" on column A.
btn "Produzi" - unhide rows in both sheets.
btn "Printaj" - your VBA code
Thanks in advance






Reply With Quote