Comments (Basic Syntax)
Formula comments are notes included with a formula to explain its design and operation. Comments do not print and they do not affect the formula; they appear only in the Formula Editor. Use comments to explain the purpose of a formula or explain the steps involved in writing it.
Comments work as in Visual Basic. Begin comments with a Rem or an apostrophe.
Note
A comment beginning with Rem is a separate statement and must either start on a new line or be separated from the previous statement by a colon.
Rem This is a comment.
Rem This is another comment.
formula = 10 'So is any text after an apostrophe.
formula = 20 : Rem This is also a comment.
'Comments can occur after the formula text.