As usual you should post your code. You could probably add the line
Columns("A:G").EntireColumn.AutoFit
or
rows("1:21").entirerow.autofit
--
Don Guillett
SalesAid Software

"PastorMike" wrote in message
...

Greetings in the Name of our Lord Jesus Christ,

I have columns of data on a sheet.
Some of the values are lengthy, and cause autorowheight enlargement.

All of the following is performed in VBA.

I suppress screen updating.
I copy/pastevalues certain columns of data from one sheet onto another
sheet for sorting.
(They must be transferred because they contain the keys to sort the
other sheet's data)
I sort the data.
I copy/pastevalues the columns back onto the original sheet.
They are now in a different order, of course, having been sorted.
The lengthy values are in different rows.
I reenable screen updating.
The autorowheight does not refresh.

I have to manually change some value on the sheet to cause a refresh of
the autorowheight.

How do I cause such a refresh with VBA?

Thanks,
Pr. Mike Gardner