Limit printing to certain 'pages' based on value

S

Stuart

How best to write this statement, please?:

If (Wkbk_PrintZeroPages = False Or _
Wkbk_PrintBlankPages = False) Then
'do not print empty/blank or zero pages,
'so test the 'total' cell for this page:
If (Pagevarr(i+1).Offset(-1, £Col).Value = 'blank/empty
' Or
"0"
' Or
"0.00"
' etc
Then Exit For
Else
Printvarr(i).PrintOut
End If
End If

Would I cover all bets with this statement?:
If the value in the total cell is Numeric and > zero Then?
seeing as there should only be numeric entries in the total cell,
if anything at all.

What's my best solution, please?

Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Select is the solution - how to avoid Select 2
Printing ranges error 0
Check for values in column A and if found then column B must have value. 3
Hide Co9lumns based on cell value 6
Macro stops running if date is not in past... 3
Check cells in a column 2
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Double click fails to run the code, just selects the cell 12

Top