How to Split VBA code in New lines

[naveenmarapaka]

Hi all,
i am finding difficulty to split the VBA code to new lines.
getting error always as i tried many ways with _ , VBLF etc

pls help to solve it

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[ianxwood]

Hi

Since the total formula is 1 string you`ll need to close it at each line break and then concatenate and reopen the string on the next line E.G.

Please Login or Register  to view this content.

Regards
Ian

[naveenmarapaka]

Thanks a million , Its perfectly working.