If statement scenario


I have a scenario where I want to exit sub if ("Summary").Range("C17").Text = "Yes" and either CBL or RBL does not equal zero. I thought the below code would work however if CBL = 0 and RBL = 100 the code will not exit sub.

 Dim CBL As Long  CBL = Worksheets("Summary").Cells(97, Yearcol).Value  Dim RBL As Long  RBL = Worksheets("Summary").Cells(101, Yearcol).Value  'Check if prestage two projects     If Worksheets("Summary").Range("C17").Text = "Yes" And RBL Or CBL <> 0  Then 


Category: vba Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.116 (s). 12 q(s)