![]() |
|
#1
|
|||
|
|||
![]()
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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
Prevent cell from expanding vertically. | snowboarder2 | Word Tables | 1 | 08-24-2016 02:52 PM |
![]() |
rick10r | Excel | 1 | 07-05-2016 12:07 PM |
Data Validation - Prevent blank cell based on a condition | dawd | Excel | 2 | 08-12-2015 05:44 AM |
Word tables: prevent word from highlighting whole cell when I highlight text | skylark53 | Word | 2 | 08-04-2015 08:12 AM |