Formula gives an error but works in the worksheet

[Kurt]

Hello All,

I am trying to using this line in some vba code:

Range("AF2").Formula = "=IF('RawData Old1'!A2=0,"Base Bid", "Alternate - " & 'RawData Old1'!A2)"

This is the exact formula that is currently working on the worksheet.

Why is the code stopping on the word Base?

I thought that might be a reserved keyword so I even tried to change it to Base1 but it still will not work.

Can someone clue me in on this?

Kurt

 

[Norie]

Kurt

You need to double up the quotes.

Range("AF2").Formula = "=IF('RawData Old1'!A2=0,""Base Bid"", ""Alternate - "" & 'RawData Old1'!A2)"

 

[Kurt]

Kurt

You need to double up the quotes.

Range("AF2").Formula = "=IF('RawData Old1'!A2=0,""Base Bid"", ""Alternate - "" & 'RawData Old1'!A2)"

Thanks Norie!

Yes that was the issue!

Have a great week!