Ampersand commas and quotations in VBA formula
Posted on 2014-12-04
I have a this formula that is part of my manual code:
I want to convert this to a VBA process and I am having trouble with the literals & and " in the output. Here is what I am trying and it isn't working.
Range("B2:B" & lastrow).Formula = "IF(A2=A1,B1&" & "", "" & "&C2" & "," & "C2)
It isn't working and I am just not good at putting in the literals. Help please.