Does anyone know how to copy data from one cell to comments of another cell?
R Richard Miller Jul 30, 2003 #1 Does anyone know how to copy data from one cell to comments of another cell?
J Jason Morin Jul 30, 2003 #2 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
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
D Dave Peterson Jul 30, 2003 #3 And you got a few other replies to your first post: http://google.com/[email protected]
