Splitting very long code over multiple lines in the editor....

I'm writing a section of code to change the formulas on a worksheet based on user selection of a drop down box. The method is straight forward, using the worksheet_change event to trigger.

However, one of the selections requires the adding together of various formula and the VBA editor is running out of space on a line to put the entire entry on one line. If I try to _ and split it over multiple lines it's giving me an error.....Expected: List separator or ). And the first : on the next line will be highlighted.

Please Login or Register  to view this content.

And it all works fine if it's on one line. It's been a very long day, I'm knackered, ran out of coffee 3 hours ago and I'm pretty sure this is going to turn out to be a bonehead question that's bloody obvious.

See, told ya it was going to be a simple, bonehead question.

Thanks!

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!