strCode = strCode & "If Range("expi 1

[simoncpage]

strCode = strCode & "If Range("expiry" & i & "&quot.Value = "" Then" & vbCrLf

Having trouble with the above string as the extra "" used in the range is throwing up an error how can I add this as a string, any help would be really useful!

Thanks
Simon

 

[lespaul]

Are you trying to add a blank space? Or are you trying to include a " in the string?

 

[simoncpage]

Trying to include "

 

[segmentationfault]

Replace all " within your string with Chr(34)