View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Aviashn Aviashn is offline
external usenet poster
 
Posts: 17
Default "If" Formula in VBA

Try doubling your double quotes within the string. VBA does not like
double quotes inside a string and the workaround is to use two double
quotes wherever there was one.

Range("B20").formula = "=IF('Sign 2'!P650,'Sign 2'!E10,"""")"

Post back if you still get an error.