Vba macros

[akhilkuhad]

ch as string
ch = ch & "}}}],""must_not"":[{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}},{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}}


I would like to split it into many lines. How do I do it ?


I tried using underscore but it didn't helped .

I'd appreciate it if someone can kick me in the right direction!

Thanks!

 

[Dryver14]

did you try space underscore?

 

[akhilkuhad]

@Dryver14
I tried space underscore but didn’t worked .

I tired putting & also .

 

[njimack]

I usually use vbcr

 

[akhilkuhad]

Hi Neil ,

Can you tell me how to use vbcr in -
ch = ch & "}}}],""must_not"":[{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}},{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}}

 

[njimack]

ch = ch & "}}}],""must_not"" & vbcr & :[{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}},{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}}