VBA Code

[Chissa]

Hello there,

Please can someone help me. I am writing a VBA code which I need to include this formula:

"=IF(Allocation!B5="DR",Allocation!D5,-Allocation!D5)"

But for some reason it does not work returns the message "Compile Error: Expected: list or seperator or )"

Allocation is the name of a different worksheet

Thank you very much

 

[Andrew Poulsom]

Like this?

ActiveCell.Formula = "=IF(Allocation!B5=""DR"",Allocation!D5,-Allocation!D5)"

You need to double up the quotes within the formula string so that VBA can parse it.

 

[VoG]

You need to doouble up the quotes inside the formula like this

Range("A1").Formula = "=IF(Allocation!B5=""DR"",Allocation!D5,-Allocation!D5)"

 

[Chissa]

Thank you both very much!