View Single Post
 
Old 08-13-2019, 08:35 PM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Competent Performer
 
Join Date: May 2017
Posts: 159
eduzs is on a distinguished road
Default

Select the column B of the used range, right click the selection and select Format Cells Menu, in Alingment enable "Wrap text" option, do this before copy to word.
To insert this procedure into your macro you can do something like this:
oRange.columns(2).wraptext=true
Backup before test.
__________________
Backup your original file before doing any modification, test in a throwaway copy of your file.
Reply With Quote