if ... or ... then ?

C

Chip Pearson

Max,

You can write your code in a way similar to the following:

If X = something Or Y = something_else Then
' do something
Else
' do something else
End If

If both X and Y are boolean variables (or if they are numeric and you want
to test whether either is not equal to zero), you can simplify the If
statement to

If X Or Y Then


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top