It's got the same limits as any cell in Excel. I think the cap on characters
that can be displayed is somewhere around 250 or so.

If you are referring to the number of characters before it wraps the text,
then that is dependant on the width of the column.

"ben" wrote:

Activesheet.Range("A1").Justify
This method cuts off text if it is over a certain limit, question is the
Justify method limited to a certain text length and if so what is that limit?

--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?