Copying and Pasting Cells to Word (size is changing, screenshot included)

Hello,

I used the macro recorder to figure out how to copy and paste a certain cell range from excel into word. If I do it manually it looks very neat and close packed as if it was actually in excel. When I use my macro it now double spaces everything and the table is huge (taking up a full page...)


This is part of a huge macro which auto-generates documents so I will just show you the necessary part.

Please Login or Register  to view this content.

Here is a picture which shows the difference http://i.imgur.com/H8UJGV9.png

Please help, thanks!