In a cell i have the formula below. I would like to put this in a vba module and set range("m3").formula =

="UPDATE dbo.tbl SET cola='" & G3 & "', colb='" & H3 & "', colc='" & I3 & "', cold=COALESCE(NULLIF('" & J3 & "',''), cole), colf=COALESCE(NULLIF('" & K3 & "',''), colg),colh = COALESCE(NULLIF('" & L3 & "',''), coli) WHERE colj = " & D3 & ";"

Its been a while since i have played with this and have tried a few times but failed. I would also like to use & _ to break this into a viewable sql like format.

Thank you for the help