Hi.
I posted a problem i thought i had earlier today about multiple if statements and it turned out that there was no issue but rather something else in the code was messing up the if statements.
However, i just ran into a different issue and am hoping someone can help me out on it. I reviewed it many times and looked for any portions of the code that might cause a bug but so far everything seems in its place but it's still not executing properly.
If IsEmpty(Range("E3")) And IsEmpty(Range("F8")) And IsEmpty(Range("F10")) And IsEmpty(Range("F14")) Then
MsgBox "No customers found!"
Exit Sub
If IsEmpty(Range("E3")) And Not IsEmpty(Range("F8")) Or Not IsEmpty(Range("F10")) Or Not IsEmpty(Range("F14")) Then
MsgBox "You forgot to enter name for customer as seen on the ""Orders Chart""!"
Exit Sub
End If
End If
'IF E3 IS NOT EMPTY THEN THE REST OF THE CODE (which i omitted as it's not important) SHOULD EXECUTE
If Not IsEmpty(Range("E3") Then
'
'
'
'
'
'
I am trying to have the rest of the code (which i did not post) to execute if E3 is NOT EMPTY.
Any ideas?
Bookmarks