Should be easy but!!!!!

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFitMergedCellRowHeight Limitation 2
Knowing where text will wrap 3
Autosize bug in Excel 2007 shape textframes 8
VBA code for pasting links -- modifying RDB code for summary workbook 10
Identify when Excel is displaying ### in a cell? (contents>width) 1
Wrapping multiline text in merged cells 1
Macro that will insert a simple text string in top cell of text file 1
Autosize bug in Excel 2007, textboxes, work arounds 1

Back
Top