CODEWITHSUNDEEP
vbaexcel
Shashank
Shashank

Reputation: 73

Error with IF/OR in VBA

.Range("BS2:BS" & NewLastRow).Formula = "=IF((OR(BR2=""FLAG"",BO2>0)),""FLAG"",""NOFLAG"" ))"

I am using this formula in VBA but it is not working. Syntax looks fine.

Upvotes: 0

Views: 96

Answers (2)

Vityata
Vityata

Reputation: 43565

In general, try the following:

  • Make a workable formula in Excel
  • Then select the cell with the workable formula
  • Run the following code
Public Sub PrintMeUsefulFormula()

    Dim strFormula  As String
    Dim strParenth  As String

    strParenth = """"

    strFormula = Selection.Formula
    strFormula = Replace(strFormula, """", """""")

    strFormula = strParenth & strFormula & strParenth
    Debug.Print strFormula

End Sub
  • In the immediate window something useful should be printed.

Source: Apply formula in VBA?

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152450

Too many ")"

.Range("BS2:BS" & NewLastRow).Formula = "=IF(OR(BR2=""FLAG"",BO2>0),""FLAG"",""NOFLAG"" )"

Upvotes: 3

Related Questions