Also look at Edit=Fill=Justify

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in
message ...
funny when I answer my own question No?
place text into an unused column, autosize then take the size of that
column.

any other thoughts?

--
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?


"ben" wrote:

Sorry, I always press the wrong button there.


Question is

if a user enters text into a cell, is there a way to determine just how
long
that text is in point size. IE the range("a1").width = 21,
range("A1").value.width = 22
I know excel manages it somehow so it can do autowidth of rows and
columns,
is their a way to determine that programmaticaly so I can divide the
text
into more cells without changing the size of the cells or autofitting
the text


--
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?