Should 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

Should be easy but!!!!!
 

Try setting your vertical alignment to top or center.

"Anthony" wrote:

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

Should be easy but!!!!!
 

will give it a go. Seems to work in a quick test.

Thanks

Anthony

"JLGWhiz" wrote in message
...
Try setting your vertical alignment to top or center.

"Anthony" wrote:

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

Should be easy but!!!!!
 

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
"JLGWhiz" wrote in message
...
Try setting your vertical alignment to top or center.

"Anthony" wrote:

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