 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Should be easy but!!!!!
Hi All, I have a workbook which copies information into a woksheet before it is printed. The information at the moment has to be limited to avoid, text becoming to small (this not the issues, am aware as I set the test size up). Cell width autosize is not a problem, but resizing the cell depth is. If I use text wrap, some of the text is missed of and I am not sure how to resize the depth of the cell in VBA. Can anyone help. Using Excel 2003 pro Regards Anthony Try setting your vertical alignment to top or center. > Hi All, > [quoted text clipped - 11 lines] > > Anthony will give it a go. Seems to work in a quick test. Thanks Anthony > Try setting your vertical alignment to top or center. > [quoted text clipped - 16 lines] >> >> Anthony I had to reprogram the routine and I also redesigned the page that recieved the info, so it was not spannign mulitple cells, but had single cells. By doing this excel correctly sizes each and every time. Anthony > Try setting your vertical alignment to top or center. > [quoted text clipped - 16 lines] >> >> Anthony |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.