Gary''s Student;506433 Wrote:
I am looking for a UDF that will return the visible text in a cell.
For
example, if A1 contains the sentence:

"Now is the time for all good men to come to the aid of their party"

The end of the sentence will "bleed" over into B1 unless column A is
very
wide. I want to see the portion of the sentence that actually appears
in A1.

I have been able to get this with a Sub, but not a Function.


--
Gary''s Student - gsnu200905

How about posting your code so that we don't have to start from
scratch?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=139234