Macro to format comments

  • Thread starter Thread starter pcor
  • Start date Start date
P

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
 
May get you started

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