hi guys , i need advice on VBA code on Pastespecial FROM excel to Words


i have a range of cells are name ( name manager ) call "Printtowords"
containing text , picture and fomulas and other stuff.

which then copy this range into a new Words document by paste special : pasteOLEObject ( so that i can double click the paste object in words to open excel and edit from there )

and second part is if there is any excel vba codes to adjust the words alignments after the paste?