Sorry, not that I could figure out. In the code, I just set the horizontal
distance I wanted. Then, I found the width of the one very long line. From
there, I calculated the approximate verticle size. So no, I don't know how
to do it automatically, but the code I displayed does what I described above.

"bparker" wrote:


Thanks for your help! The automatic size thing is nice, but it makes it
all one very long line! Can I set a maximum horizontal size so that it
will automatically size vertically, adding lines where more are
needed???
Brad


--
bparker
------------------------------------------------------------------------
bparker's Profile: http://www.excelforum.com/member.php...o&userid=34940
View this thread: http://www.excelforum.com/showthread...hreadid=546820