Posts by dal3gacy

    Good day,

    i've created a 32 workseets in a workbook. First worksheet (named DATA) has the days of the month (01, 02, 03, ....31) in the column A, weekdays by name in the column B and in column C based on the day of week (workday or weekend day) has the value 1, respectively 0. The rest of the worksheets are named 01, 02, 03, ....31. All these last 31 worksheets have the same format.

    I would like to be able to print ( in a single print comand, without going from worksheets 01 to worksheet 31) all the workseets that are coresponding to the workdays in a month, WITHOUT the weekend days.

    can someone give me a solution? is it doable?

    I've googled for a few days now, and none of the solutions that i've found couldnt get it to adapt to my specific problem. also i'd like to mention that i have very little knoledgo of macros or VBA.


    Hello to everyone. I am looking for a solution to combine or merge two VBA codes that handles the printing. First VBA (that works) does the folowing:
    -checks the second column for 0(zero) value and where it finds it the row that contains 0 (zero) on column 2 will be hidden. This VBA code runs whenever the "Print Preview" or "Print" is pressed. This VBA code works like a charm. And it is only for THE FIRST WORKSHEET.

    The second VBA should be working together with the first VBA code, additionally should check 3 different cells A1, A2 and A3. These 3 cells can only have two values: 0 or 1. If value in A1 is 1 it should print Sheet2, if A1 is 0 to not print it. If value in A2 is 1 it should print Sheet3 if A2 is 0 to not print it and so on.

    These two VBA should handle the final printing.

    I would totally appreciate any ideas, as i am a noob in the VBA coding.

    Thank you