Have you considered shrink to fit?
--
HTH,
Barb Reinhardt




"ranswrt" wrote:

How do I write a code that will not allow a string to be wider than the cell
that it is going into? The with of the cell is 27.86 (200 pixels). The
problem I have is I can't limit the number of characters because they are
different widths depending on the character.
Thanks