View Single Post
 
Old 05-12-2019, 12:42 PM
sts023 sts023 is offline Windows 7 64bit Office 2010
Hopeless Idiot
 
Join Date: Apr 2019
Location: God's Own County
Posts: 26
sts023 is on a distinguished road
Default

See attached images.

"Pre.jpg" (1st image) shows the table as created by VBA.

"Post.jpg" (2nd image) shows the result after using the Word ribbon's "Home/Paragraph/Paragraph Line and Spacing" to select "1.0" and "Remove Space After Paragraph".

Note that as "Show Formatting" is ON, there are no carriage returns or line feeds at the end of the cell's text in either image.

I want to use VBA to achieve programmatically what I get manually from the ribbon, i.e. the cell Height of each row in the table is reduced to fit the text, whilst the cells Width is unchanged.
Attached Images
File Type: jpg Pre.jpg (19.6 KB, 19 views)
File Type: jpg Post.jpg (22.5 KB, 19 views)
Reply With Quote