Re: Print if cell contains value
Please see the modified copy of what I exactly require.
Sheet1 named Rent contains all the details of the party.
Sheet2 named Rent bills contains all the bills made.
Currently When I click command button print it prints only pages 1 and 2 from the sheet named Rent Bills, and not all what I require.
Now what I exactly require is
The print out should be taken only when Cells in F contains a value.
Here F6 contains the value so it should print page 1 and 2
Here F7 contains the value so it should print page 3 and 4
Here F8 does not contains any value so it skip
Here F9 contains the value so it should print page 7 and 8
and so on
Before printing a dialog box should appear asking to select the printer only once and not for all printouts.
Hope I am now clear.