I need a bit of help from the more experienced Excel VBA users.
Basically I have 2 groups of 3 cells (6 cells total) If one group of 3 cells is filled in it needs to accept it and not return a messagebox.
If one of the two groups is not filled in (blank) or returns an error it needs to show an "error msgbox"
The two groups of 3 cells are : (A39,A40,A41) and (E39,E40,E41)
This is currently in my formula:
If IsError(Range("E39, E40, E41")) Then MsgBox ("error msgbox"): Exit Sub If Range("E39, E40, E41") = Blank Then MsgBox ("error msgbox"): Exit Sub
How do I add A39,A40,A41 to this formula so that if either group 1 (A39,A40,A41) or
group 2 (E39,E40,E41) are filled in it does not return an "error msgbox"?
I've tried fiddling with it myself but it would return an "error msgbox" if all 6 cells weren't filled in.
I have tried looking at AND, OR statements but I can't quite get the function I want.
Here is a picture which may help
Any Help would be greatly appreciated