SYNTAX ERROR QUESTION - EXCEL

Discuss syntax highlighting or submit new syntax files.
Post Reply
tim_crouse
Posts: 60
Joined: 12 Apr 2024 00:22

SYNTAX ERROR QUESTION - EXCEL

Post by 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
EXCEL SYNTAX BRACE ERROR QUESTION.png (22.91 KiB) Viewed 3328 times
Attachments
Excel.zip
(2.61 KiB) Downloaded 282 times
User avatar
Rickard Johansson
Site Admin
Posts: 6710
Joined: 19 Jul 2006 14:29

Re: SYNTAX ERROR QUESTION - EXCEL

Post by 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
Posts: 60
Joined: 12 Apr 2024 00:22

Re: SYNTAX ERROR QUESTION - EXCEL

Post by 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
User avatar
Rickard Johansson
Site Admin
Posts: 6710
Joined: 19 Jul 2006 14:29

Re: SYNTAX ERROR QUESTION - EXCEL

Post by 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 170 times
Post Reply