SYNTAX ERROR QUESTION - EXCEL

[tim_crouse]

If anyone has time would you mind looking at the attached Excel Syntax file and explain to me how to correct a brace detection error, the brace grouping appears correct to me, but the app is seeing an error:

1. What is needed to change to get eh brace error checking to behave properly (see image)?

Thanks in Advance
-Tim C.

EXCEL SYNTAX BRACE ERROR QUESTION.png (22.91 KiB) Viewed 4596 times

[Rickard Johansson]

I just took a quick look - and I think it's because you're using ' (single quote) for line comment, but in the text you're using it as a string?

[tim_crouse]

So, in Excel

' is allowed to be used in formulas to create a comment, albeit only at the end of the line.
But in the middle of a formula, it is required when referring to TABs.

So I am guessing without a bunch of logic put in the code it is pretty much what it is.

Sound about right?

Best Regards
-Tim

[Rickard Johansson]

You could do something like below. The downside is that comments and ' ' blocks are highlighted with the same color.

Excel.zip

(2.67 KiB) Downloaded 192 times