I am inserting formulas into cells using a macro. Several formulas require
a
blank. (" ")

Ex1: Sheets("Frame 6").Range("G3").Value = "=IF(ISERROR(VLOOKUP(A3," &
CSpath & ",29,FALSE))," ",VLOOKUP(A3," & CSpath & ",29,FALSE))"

Ex2: Sheets("Frame 6").Range("F3").Value = "=IF(D3=1,VLOOKUP(A3," & CSpath
&
",34,FALSE)," ")"

However, Excel won't let you do this. How can I get the blanks in there?
Thanks in advance.

Because VBA uses quote marks to delineate String constants, you can't just
use them as is inside of a String constant in order to include them within
that String constant. If you double them up, however, VBA will treat the
doubled up quote marks as if they were a single included quote mark. Here is
your first example modified to account for this...

Sheets("Frame 6").Range("G3").Value = "=IF(ISERROR(VLOOKUP(A3," & CSpath &
",29,FALSE)),"" "",VLOOKUP(A3," & CSpath & ",29,FALSE))"

Notice that your " " has become "" "".

Rick