I think this is quite a simple one

i am using a macro to put a formula in a cell, however as it contains speech marks (") it does not work, is there a way to get it to understand the speechmarks within the outer speech marks are part of the formula i want typed in the cell

Worksheets("Customer Form").Range("C13").Formula = "=IF(Data!K11 = "New Manager", "Please Overtype With Name Of New Manager","")"