Filling the formula i.e =IF(D1=””, “N”,”Y”) into cells using VBA

Hi,

Anyone know how how to convert the formulas with double quotes(“) to VBA code?

1) =VLOOKUP((H8 & “”), $A$2:$E$1135,2,FALSE)
2) =IF(D1=””, “N”,”Y”)
3) =IF(ISNA(H2),1,IF(H2=0,”N”,”Y”))

The double quotes are causing the problms:(

Thanks,
Michael