I have, but I would rather stop the string at a certain width. I would have
to go thru multiple sheets and cells and format them to shrink to fit.
"Barb Reinhardt" wrote:

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