Microsoft Excel Functions & Formulas

Use a user-defined function to find

all comments

Cells with comments have red indicator triangles in the upper-right

corners. Usually the comments are hidden and only appear if the

mouse pointer is rested over that particular cell. It is also possible

to hide the red indicator. One way to review all comments is to click

Comments on the View menu. It is also possible to create a

user-defined function that returns True if a comment is found.

4

To check whether a cell contains a comment:

1. Press <Alt+F11> to open the Visual Basic Editor.

2. From the Insert menu, click Module.

3. Type the following function:

Function ComT(rng As Range)

On Error GoTo errorM