Printing a variable's value into a cell using vba

[jebenexcel]

Hello guys,

I want to use VBA to assign the variable formula b into some cells inside a for loop. If I use .formula = "b" instead of .formula = b, i get the string "b" in the correct places. How do I get VBA to write b's value into those cells? What is the correct syntax? Should the &s be +s? Cause that didn't work either. There's probably a combination of wrong things in this code...

code:

b = "=IFERROR(IF('OBR1 (" & i & ")'!C13<>"";'OBR1 (" & i & ")'!C13;'OBR1 (" & i & ")'!C3);"")"
    Sheets("a").Range("B" & j).Formula = b

 

[Norie]

Try this.

b = "=IFERROR(IF('OBR1 (" & i & ")'!C13<>"""";'OBR1 (" & i & ")'!C13;'OBR1 (" & i & ")'!C3);"""")"
    
Sheets("a").Range("B" & j).Formula = b

 

[jebenexcel]

Runtime error '10040
Aplication-defined or object-defined error

 

[jebenexcel]

'1004'*

 

[Norie]

VBA probably doesn't like the ; separators, try this.

b = "=IFERROR(IF('OBR1 (" & I & ")'!C13<>"""",'OBR1 (" & I & ")'!C13,'OBR1 (" & I & ")'!C3),"""")"