var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: VBA string concat for cell formula
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