Hi,
I'm trying to paste a range into word using vba, and am currently using the following code (thanks to the original author):
The trouble is, when a cell in the required range has too many characters, instead of 'wrapping' the text (like it does in excel), it throws the column sizes.
What can I change in the above code to make it paste while maintaining the column sizes of the excel spreadsheet? I don't want to keep any gridlines or tables, just the text. The code currently works brilliantly, as long as no cells have too much data in them.
Thanks in advance.
Bookmarks