LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 413
Default If....Or Logic question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Logic question palhota Excel Worksheet Functions 5 October 20th 08 08:01 PM
IF(?) logic question Dave Excel Discussion (Misc queries) 3 February 10th 07 12:28 PM
Count logic question ACDenver Excel Discussion (Misc queries) 7 August 17th 05 04:28 PM
Logic question ACDenver Excel Discussion (Misc queries) 1 August 16th 05 04:29 AM
Logic Question - Can you help please Leo Heuser[_2_] Excel Programming 0 July 16th 03 03:30 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"