View Single Post
 
Old 04-01-2015, 02:15 AM
Marco Marco is offline Windows Vista Office 2007
Novice
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default 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
Reply With Quote