The formatting of the last paragraph in the range requires the paragraph mark to be included since that is where the paragraph formatting is held. But you could also just apply the last paragraph formatting to the pasted area after the copy has happened.

The property you should be using is .FormattedText
Do a search for this term on this forum to see examples which duplicate ranges with formatting.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia