copy data to comments

  • Thread starter Thread starter Richard Miller
  • Start date Start date
Try this:

Sub CopytoComment()
Range("B1").Comment.Text (Range("A1"))
End Sub

Note: I'm assuming B1 already has a comment. Also,
anything already in the comment will be overwritten when
macro is run.

HTH
Jason
Atlanta, GA
 
Back
Top