Writing a word from VBA into excel - Xtreme Visual Basic Talk

03-16-2009, 05:15 AM

jwvdpoll

Freshman

Join Date: May 2008

Posts: 36

Writing a word from VBA into excel

Hello,

I have a logical function:

Code:

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.

03-16-2009, 05:40 AM

Technoboy

Freshman

Join Date: Jul 2008

Posts: 26

Change to:

Code:

Range("AS34").FormulaR1C1 = "=if(" & _
        Range("AS34").Offset(0, -2).Address & "<" & _
        Range("AS34").Offset(0, -1).Address & ",""Turbulent"",""Laminair"")"

Note that the double quotes ("") mitigate the syntax error and in code represent a single set of quotes.

Last edited by Technoboy; 03-16-2009 at 05:42 AM. Reason: Incorrect Post

03-16-2009, 05:42 AM

Colin Legg

Out Of Office

Retired Moderator
* Expert *

Join Date: Mar 2005

Location: London, UK

Posts: 3,398

Code:

    Range("AS34").FormulaR1C1 = "=if(RC[-2]<RC[-1],""Turbulent"",""Laminair"")"

__________________
RAD Excel Blog

03-16-2009, 09:04 AM

jwvdpoll

Freshman

Join Date: May 2008

Posts: 36

That easy huh.

Thanks!