Hi there,

Just a quick question as to how do I use the "AND" & "OR" operators in VBA. I know you can do it in excel where "AND(Logical,,,)" [same for OR], can be used. But how do I do that in VBA? What happened if I have and IF statement were it goes something like this:

if (X>0) then
if(y>0) then
do something
end if
end if

I can truncate to something more easier

if(X>0 "and" y>0) then
do something
end if

I know you can do it with Java where "&&" can be used for "AND"

Thanks

Phil