Cell Comments -- Example

Example Generated by CommentTestGeneration Macro (#...)

This Example is a continuation of Cell Comments.

Coding used on this page can be found in http://www.mvps.org/dmcritchie/code/comment.txt and in http://www.mvps.org/dmcritchie/code/join.txt

The following spreadsheet was generated by the CommentTestGeneration Macro which simply served to create some test data with text and comments.  The range E11:F13 was selected within and the MarkCells and TextToComments macros were run within the CommentTestGeneration Macro.  The results and the CommentTestGeneration macro are show after this section.

Results of PrintCommentsByColumn Macro (#...)

Cell comments by default are printed (pagesetup/sheets) by row then column.

The PrintCommentsByColumn Macro to populate another sheet with comments by column macro described on the <a href="ccomment.htm">ccomment.htm</a> page  will populate a new worksheet with the cell address, cell.text and the cell comment.  You can view or print that worksheet.  The display here is down one column and then down the next column(s) for cells that have comments.

Related   (#related)

• Cell Comments and the related Code page contains the following macros:
  • FormulasIntoComments
  • TextIntoComments
  • CommentTestGeneration -- described on this page, coding on code page with rest of these.
  • PrintCommentsByColumn
• MarkCells macro generates data mainly used for testing by placing the cells address as the value for each cell in the selected range.
• PROPER and other macros contains information on use of SpecialCells to find Comments, and use of INTERSECT to reduce the range by finding the intersection of two or more ranges.

Please send your comments concerning this web page to: David McRitchie send email comments

Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved