Thanks Dave, but I want to put the test in a vba sub, in an if...then...else
statement. Sorry if I did not make myself clear.

I tried concocting something like that statement , which I would put in a
formula, and got error messages I couldn't interpret.

Matilda



"Dave Peterson" wrote:

=if(and(a1<"",b1<""),"dothing", "donothing")

Matilda wrote:

Dear All,

I want to execute a statement if two cells meet the same condition (ie not
empty).

Basically, I want the vba syntax for the formula

if(or(A1, B1, <""), doThing, doNoThing)

Many TIAs

Matilda

--

Dave Peterson