Does any know of a way that I can have a range paste in to Excel and have it select the "fits to content" option in Word.

I have the macro built that copies in to word but I have to manually go in and select "Fits to Content" from the Table Tools - Layout Tab.

Any help would be appreciated. Here is my copy code I have setup. 


Please Login or Register  to view this content.
Thanks in advance