VBA formatting problem - Excel to Word

basically, work has asked me to create a macro that will transfer information from an excel to a word document. The code that i have created copies the excel info into a freshly made word page, but then i try to get it to unformat the text, and it doesnt work!

here is my code:

Please Login or Register  to view this content.

what should i add and/or change to the code to make it change the format to unformatted.
if you have a working paste special code that will make it unformatted then please try and add it and test it. It would be much appreciated, it has been doing my head in for 2 days now

thanks guys

You could just change your last line to:

Please Login or Register  to view this content.

to paste as plain text.