Macro to format comments

[pcor]

I am using EXCEL 2007 and would very much like to have a macro that would
allow me to format all my "Comments" in the various cells.
Thanks for the hlep
Ian M

 

[Don Guillett]

May get you started

Sub formatcomments()
With ActiveSheet
For i = 1 To .Comments.Count
MsgBox .Comments(i).Text
Next i
End With
End Sub

 

[Gord Dibben]

See Debra Dalgleish's site for code.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben MS Excel MVP

 

[pcor]

Thanks to YOU and Debra
Worked great

See Debra Dalgleish's site for code.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben MS Excel MVP



.