tables: fit only long lines to avoid line break
Dear all, I am new to this forum.
I ask your help for the following question.
I have a table produced by mail marge from an access DB.
The column width is fixed and quite fitting that of the lines it will contain. However some lines may be a little longer and break, which is not wanted.
Since I guess there's no other way to get the result, I would like to add a VBA code to shrunk lines too long in the column width I chose.
The result is similar to the option "fit text" in the cell options, but this will also stretch short lines, while I only want to shrunk long ones.
Any suggestion?
Thanks, Marco
|