How to paste with formatting but without comments?

[New Daddy]

Is is possible to copy and paste text from another document with the formatting from the original document intact but without the comments?

I'm trying to incorporate a work done by a colleague into the master document, but I want to strip the comments.

[Rudi]

Could you not delete all comments first from the source you are copying, then copy and paste into your master.
Simply close the source without saving to retain the original comments.

[macropod]

Or you could use a macro for the paste and comment removal...

Code: Select all

Sub Demo()
With Selection.Range
  .Paste
  While .Comments.Count > 0
    .Comments(1).Delete
  Wend
End With
End Sub

[New Daddy]

Could you not delete all comments first from the source you are copying, then copy and paste into your master.
Simply close the source without saving to retain the original comments.

That's an excellent idea!

Thanks.