Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's the code:
If (Global_PrintZeroPages = False Or _ Global_PrintBlankPages = False) Then If Not Pagevarr(i + 1).Offset(-1, £Col).Value _ "0.00" Then GoTo Line200 End If End If The code should test the 2 'Global' variables (dimmed as Boolean). If either are set to False, then it should look at the value in the range Pagevarr(i + 1).Offset(-1, £Col). If "Global_PrintZeroPages = False" is True then it should test for the value "0.00". If "Global_PrintBlankPages = False" is True, then it should check for an empty cell (ie no textual nor numeric entry). If either value meets the criteria, then GoTo Line200, else continue the routine. How do I achieve this please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.706 / Virus Database: 462 - Release Date: 14/06/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logic question | Excel Worksheet Functions | |||
IF(?) logic question | Excel Discussion (Misc queries) | |||
Count logic question | Excel Discussion (Misc queries) | |||
Logic question | Excel Discussion (Misc queries) | |||
Logic Question - Can you help please | Excel Programming |