jwvdpoll
03-16-2009, 05:15 AM
Hello,
I have a logical function: Range("AS34").FormulaR1C1 = "=if(RC[-2]<RC[-1],Turbulent,Laminair)"
This checks the velocity of adjecent cells and puts either the words turbulent of laminair in its own cell. But if I do it like this excel will give a #NAME error and if I put " around the words in VBA it will give a syntax error.
How can I fix this.
I have a logical function: Range("AS34").FormulaR1C1 = "=if(RC[-2]<RC[-1],Turbulent,Laminair)"
This checks the velocity of adjecent cells and puts either the words turbulent of laminair in its own cell. But if I do it like this excel will give a #NAME error and if I put " around the words in VBA it will give a syntax error.
How can I fix this.