Maybe you might need code to send the data to a textbox then print the
contents of the textbox.



"jsAlpha" wrote:

I am having an issue with printing wrap text. On the screen, the wrap text
apears fine. However, when I print to paper or tif image the data is
sometimes truncated or chopped off at the top and or bottem. This issue
mainly occurs when the column width is 255 but I have seen it in other
instances. My process is automated so that it Autofits the columns, selects
wrap text, Autofit the rows, and then print the sheet. I understand that
characters past 1024 will not be displayed in a cell, so that is not the
issue. The example that I am using to try to solve the problem is only 279
characters, Font: Ariel, Size: 8. I am using Excel 2000 in a Windows 2000
environment. Thanks