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

**nwd9s** · 06-09-2011, 09:52 AM

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** · 06-09-2011, 09:55 AM

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** · 06-09-2011, 10:17 AM

Originally Posted by nwd9s

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** · 06-09-2011, 10:28 AM

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