Thanks for the reply. The ranges in excel are not to be chosen by the user, they are predefined and constant. I already have the part of the macro that will select the relevant table in word, paste the contents of the clipboard and format it.... Just don't know how to get it to the clipboard using the macro.