Page 1 of 1
SYNTAX ERROR QUESTION - EXCEL
Posted: 16 Apr 2024 13:10
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 (22.91 KiB) Viewed 6651 times
Re: SYNTAX ERROR QUESTION - EXCEL
Posted: 16 Apr 2024 15:04
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?
Re: SYNTAX ERROR QUESTION - EXCEL
Posted: 16 Apr 2024 18:30
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
Re: SYNTAX ERROR QUESTION - EXCEL
Posted: 17 Apr 2024 11:50
by Rickard Johansson
You could do something like below. The downside is that comments and ' ' blocks are highlighted with the same color.