Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Sub enlarge_comment()
  2. 'assumes that the current selection contains just one comment!
  3. Dim newrange As Range
  4. Set newrange = Selection.Range
  5. Selection.Comments(1).Range.Copy 'copy text of old comment
  6. Selection.Comments.Add Range:=newrange 'create new comment
  7. Selection.Paste 'add text to new comment
  8. newrange.Comments(1).Delete 'delete old comment
  9. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement