Randy,

Try something like

Dim CMT As Comment
Set CMT = ActiveSheet.Comments(1)
CMT.Shape.Height = 100
CMT.Shape.Width = 200

I don't believe you can change the default size.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Randy Harris" wrote in message
...
I need to change the size on a great many comments on a
Worksheet. I find
that this code:

Selection.ShapeRange.ScaleHeight 1.6, msoFalse,
msoScaleFromTopLeft

will change, but relative to the default size. I can't find
the syntax to
change to Height and Width settings.

Also, how can I change the default size?

Thanks for any help.