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?