Insert Simple “If” formula (2000–VBA)

Topic

New Reply

Hi,

I’m trying to insert a formula into a cell via VBA.

range(“d2”).Formula = “=IF(C2=”cd”,B2*0.66,B2)”

But I get this error message: Compile Error! Expected End of Statement.

What’s wrong?

Thanks!

Reply | Quote

Replies

Just double-up on the double quotes within the formula portion, so that the VB editor knows you want a quote in the formula, instead of ending the line prematurely, like so:

Range("d2").Formula = "=IF(C2=""cd"",B2*0.66,B2)"

Reply | Quote