Hi Everyone.

My colleague use a single (multipage) document for several partners the partner logo need inserted at various point throughout the document. Everytime her manager makes and ammendement to the main document she then has to go through it for each partner and manually change the logos.

I was trying to help her by adding images of all of the partner logos into a separate worksheet then depending on which partner she selects from a drop down box the relevanmt image would be copied and pasted into the relevant places.

Using a macro recorder I can get the images to copy and paste no problem but it pasted in the top right each time and i need it to centre horizontally across a merged ranged (the logos are all different sizes but would fit in the merged range).

I've tried to adapt several pieces of code to centre the image without any joy. Is anyone able to help please. I cannot upload the workbook but here is the code i have tried (trying to copy the image LTE from a wroksheet called logos to the worksheet8 and paste into merged range B12 then centre horizontally
Please Login or Register  to view this content.