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
EXCEL SYNTAX BRACE ERROR QUESTION.png (22.91 KiB) Viewed 1826 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.

Excel.zip
(2.67 KiB) Downloaded 86 times