I see such an If statement like "If b or b1 Then........."
So there should be such a type like "If b and b1 Then........." .
What are the differences between "If then " and above?
I see such an If statement like "If b or b1 Then........."
So there should be such a type like "If b and b1 Then........." .
What are the differences between "If then " and above?
All such statements are equivalent to "If TRUE then ...". You are testing (b OR b1), (b AND b1) or whatever for a True/False value. Try a Google search for "VBA logical operators"
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'