Locating Comments in a Worksheet

R

Ray Clark

Need to write a macro to locate comments recorded in a worksheet without
having to create a seperate list.
 
L

loudfish

Need to write a macro to locate comments recorded in a worksheet without
having to create a seperate list.
Click to expand...

Depends what you need this for. Without any VBA at all, you can get
the comments to print out:
From File, Page Setup, Sheets,
Click to expand...
Comments: At End of Sheet

If you need to locate (select) cells with comments, use
Goto....Special....Comments.
or the following VBA:

Sub SelectComments()
Selection.SpecialCells(xlCellTypeComments).Select
End Sub

For more options, I'd suggest David McRitchie's website, which
includes code for writing all comments out to a txt file:
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH

Andrew
 
Top