Hi Randy,
Another option is a close fitting comment.

Resizing All Cell Comments (#resizing)
http://www.mvps.org/dmcritchie/excel...t.htm#resizing

The following may be a fixup if you have serious problems for size of the comment box. (Format, Alignment, Automatic size). .

Sub FitComments()
Dim c As Comment
For Each c In ActiveSheet.Comments
c.Shape.TextFrame.AutoSize = True
Next c
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Randy Harris" wrote in message ..
I need to change the size on a great many comments on a Worksheet.