Hi All.

I create workbooks using MS Excel 2003. First I copy the data itself, then I
copy the data formats (using PasteSpecial Formats). I copied a range of rows
(1:23) and all the rows which have the Wrap Text property specified didn't
change their height. I find the following explanation: when Excel copies the
format of the row it also copies its height. I can change the rows height to
the required by using UsedRange.EntireRow.AutoFit method.

But when I do that, the rows, which have the Marge Cells and Wrap Text
properties specified and user-defined cells width change their height to
standard (i.e. they get the height of standard row, my setting is 17
pixels).

It's understood, that only a part of cell's text is visible, which, of
course, doesn't meet my requirements at all.

I noticed the following thing: if I've saved the workbook, closed the
workbook and opened it again, all rows, which had Merge Cells and Wrap Text
properties specified, hadn't change their height, but rows, which had only
Wrap Text property specified expanded to the required size.

Is there a way to perform this operation without saving and closing the
workbook?

Thanks, Didi

Hi Didi,

See reponse in Programming.


---
Regards,
Norman



"didi" <(E-Mail Removed)> wrote in message
news:O$Y25$(E-Mail Removed)...
> Hi All.
>
> I create workbooks using MS Excel 2003. First I copy the data itself, then
> I copy the data formats (using PasteSpecial Formats). I copied a range of
> rows (1:23) and all the rows which have the Wrap Text property specified
> didn't change their height. I find the following explanation: when Excel
> copies the format of the row it also copies its height. I can change the
> rows height to the required by using UsedRange.EntireRow.AutoFit method.
>
> But when I do that, the rows, which have the Marge Cells and Wrap Text
> properties specified and user-defined cells width change their height to
> standard (i.e. they get the height of standard row, my setting is 17
> pixels).
>
> It's understood, that only a part of cell's text is visible, which, of
> course, doesn't meet my requirements at all.
>
> I noticed the following thing: if I've saved the workbook, closed the
> workbook and opened it again, all rows, which had Merge Cells and Wrap
> Text properties specified, hadn't change their height, but rows, which had
> only Wrap Text property specified expanded to the required size.
>
> Is there a way to perform this operation without saving and closing the
> workbook?
>
> Thanks, Didi
>
>
>
>