[SOLVED] Syntax for Writing Long VBA Formula on Multiple Lines

[nwd9s]

Hi,

I have a large formula I am trying to input that is making me put it on two lines. I cannot get the syntax to work properly and was looking for some assistance. The range and actual formula all work properly, I am just looking for how to break the formula onto multiple lines in VBA.

Please Login or Register  to view this content.

Many thanks in advance for your help!

Regards,
nwd9s

[shg]

When you break a long formula, you have to catenate the sub strings:

Please Login or Register  to view this content.

It's much easier to debug if you assign the formula to a string, and print the string to the Immediate window for perusal.

[tarquinious]

Hi,

I have a large formula I am trying to input that is making me put it on two lines.

To break a long line of code into multiple lines in VBA, you use a space, then the the underscore character (i.e. " _").

[abousetta]

Hi tarquinious,

From what I have tried before the " _" only works for vba code not a formula. What shg suggested is correct. You need to close the first line with a quotation mark, add a space and an & sign then on the new line start with quotation marks.

abousetta

[nwd9s]

Thanks for your help. I have tested this, and a " & _ needs to be used for splitting a formula in vba.

Thanks,
nwd9s