That still may be a better option, although it would require that I consistently line break before the open paren rather than after.

However, it seems to require a space before the open parenthesis or to have it start a line to work. Then I thought that simply having an open parenthesis as the only Folder Open Keyword would be even better. That worked OK, but didn’t work well with FALSE as FALSE is both a potential argument and the name of a function. I started by trying to make all of the function names Folder Open Keywords and a close parenthesis as the Folder Close Keyword. Folding is collapsing certain portions of the code so the rest is easier to read.

The only thing I don’t like about it is the folding option. I downloaded Notepad++ and Bob’s xml files and gave it a try. He uses a custom language in Notepad++ to allow for indenting formulas, editing formulas, and all the other stuff you can do in a text editor that you can’t do in Excel’s formula bar.

Bob wrote a blog post last week, Formulas Made Easy, that I read with great interest.

Notepad ++ install plugin