Sorry Kenneth I don't qiute understand how to implement this? Will the code you've suggeseted keep the formatting present in excel - for example a yellow background or the cell boarder? What I'm trying to imitate is the paste special command when I bring the data into word:

[VBA]Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF[/VBA]

I've seen a code that achieves this but each bookmark has to be progrmmed seperatly rather than the more global approach this code takes - and I have a lot of bookmarks to programme!


Thanks for your help.