Results 1 to 11 of 11

Thread: [RESOLVED] Excel VBA - Print only "not empty" pages

Threaded View

  1. #4

    Thread Starter
    Hyperactive Member Zeljko's Avatar
    Join Date
    Oct 2006
    Location
    Internet
    Posts
    441

    Re: Excel VBA - Print only "not empty" pages

    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width