Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.674 / Virus Database: 436 - Release Date: 02/05/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
How can I limit Excel worksheet to 12 pages? | New Users to Excel | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Character limit when printing | Excel Discussion (Misc queries) | |||
Limit Printing of Worksheets. | Excel Programming |