Support Board
Date/Time: Tue, 26 Nov 2024 08:49:17 +0000
Post From: Adding comments to a Study Alert condition
| [2021-12-03 00:42:52] |
| j4ytr4der_ - Posts: 938 |
|
Just in case anyone else is still looking for a way to comment their code... I'm sure what the OP was asking for, is what I was also wanting: The ability to comment my code (not an Excel-style comment, which is useless IMO). Some of my work in spreadsheets has gotten quite complex, with much logic and nesting and indenting to the point that I must develop in a decent text editor and copy/paste the results into the spreadsheet. I really wanted a way to comment the code, so I came up with this approach: IF(REM="This is a comment...","",""),
Stick that line anywhere you like that's valid within your code. I can't speak to what sort of performance hit this might cause in your sheets, and maybe there's a way to optimize it for performance. All I know for sure is that this line will do nothing, but give you a nice clear visual comment in your code. Can always be pulled out for production use. Hope it helps someone! Date Time Of Last Edit: 2021-12-03 00:46:17
|