View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

You can use the normal cell comment for that.

Another drawlback: A formula can only be a max of 1024
chars long. If you have a really long complex formula and
you're nearly maxed out length wise you still may not be
able comment.

Biff

-----Original Message-----
Sometimes in worksheets the formulas can get out of hand,

and when you open a
file a while after you last touched it, you can no longer

understand some
formulas you have in your worksheets.

Can you please include syntax for cell function parser,

so that it is
possible to add any comment text after the last bracket

and it'd just ignore
it. You can even have an apostrophe like in VB to avoid

inveting a wheel.

Say, such a formula including comment could be valid in a

cell:
=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) 'counts number

of days in a
current month.


.