List Comments

Submitted by Tommy Miles.

Excel allows the user to print the comments in a workbook, but it doesn't specify the workbook or worksheet on which the comments appear. The following sample places comments, author, and location of each comment on a new sheet for easy viewing, saving, or printing. Sample results are shown in Figure 13.4.

Figure 13.4

Easily list all the information pertaining to comments.

Sub ListComments()

Dim wb As Workbook Dim ws As Worksheet

Dim cmt As Comment

Dim cmtCount As Long

0 0

Post a comment