Entering formulas via VBA

R

Ron

Hi all,

Can anyone help me with a workaround for this line of code?

Range("r2").Formula = "=IF(Q2="w",(P2*(E2-1)*0.95),-P2)"

When the compiler gets to the "w" part of the formula it's expecting "w" to
be a variable or something as it sees me as closing this part "=IF(Q2="

I'm sure there's a simple explanation that I'm overlooking?

Any help or pointers appreciated

Ron
 
N

Niek Otten

For quotes within quotes, use two quotes
Range("r2").Formula = "=IF(Q2=""w"",(P2*(E2-1)*0.95),-P2)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Function for Anniversary Dates 5
array formulas in vba help 4
Entering two functions in code 5
Brain lock: using array formula within VBA? 12
VBA - Multiple Array-Enter Command 1
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
formula strings containing quotation marks - VBA 5
Using VBA to insert dynamic formulas into a worksheet. 7

Top