PDA

View Full Version : Simple Macro to add Comments



ssinghal
01-27-2008, 06:36 AM
I want to have a macro that will simply copy the text in the current cell to a comment in that same cell. Can someone help me out?

Thanks,

Sanjeev

Carl A
01-27-2008, 07:41 AM
Range("A1").Comment.Text Text:=Range("A1").Text