Compare to sets of cells

[rpaulson]

Hello all,

my head hurts from beating it against a rock.


need to VBA code to compare 2 sets of cells to if the are Both empty or Both filled.

example: I need to return True is both cells within a set are the same State.

Example of TRUE Condition:

A1 and B1 are (Both Empty or Both Populated) AND D1 & E1 are (Both Empty or of Both Populated).

Tia,

Ross

 

[rpaulson]

bump..

 

[meldoc]

Hello

Try.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>  x = <SPAN style="color:#00007F">Not</SPAN> (Range("A1") = "" Xor Range("B1") = "") And <SPAN style="color:#00007F">Not</SPAN> (Range("D1") = "" Xor Range("E1") = "")<br>  MsgBox x<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[rpaulson]

Brian,

Works with my sample data.
Thank you very much.

Ross