Nested Formula VBA problem

[Lil8]

I am using a nested if Formula below that works if it is typed into a Excel Spreadsheet but when I add it from a form as below I get an the "Fri" is highlighted and I get an error.

Sheets("Invoice").Range("C12").Formula = "=IF(E18="Fri",VLOOKUP(B18,tblWeekendPapers,2),IF( etc etc"

Please can any one suggest why it should work if typed in but not if added via VBA coding.

Thanks Nic

 

[GlennUK]

You have embedded quotes, but you aren't converting them to be used inside a quoted string.

Look at this and adapt your row of code:

ActiveCell.Formula = "=IF(E18=""Fri"",""Hooray POETS day"",""boohoo"")"

Good luck.

Cheers, Glenn.