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

Thanks Andrew for your reply . I am not sure I understand. This is not about paragraph per se or have I misunderstood something?. I have explained it a bit more in the above post. Do let me know if you need any other information?