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