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