Multiple conditions in an IF statement in Excel VBA

The Solution to Multiple conditions in an IF statement in Excel VBA is


In VBA we can not use if jj = 5 or 6 then we must use if jj = 5 or jj = 6 then

maybe this:

If inputWks.Range("d9") > 0 And (inputWks.Range("d11") = "Restricted_Expenditure" Or inputWks.Range("d11") = "Unrestricted_Expenditure") Then

~ Answered on 2016-01-19 19:11:30


Most Viewed Questions: