OK what I mean is to take a formula (such as: if y>1 and x<1 and z=1 then Q.caption="1")
and dim it as a variable....Long(as far as I understand it) Won't allow me to use coding statements such as if/then/else....and thats what i need to use.........