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