Shame on me! I read the "All" option button to include all the formats.. From
now on I will remember to paste special twice, or three times to get values,
formulas, width, AND hieght.

Thanks to all who responded.

"Peo Sjoblom" wrote:

You can paste as column width but as row height, you have to do it in 2
operations, first for instance do editpaste special and select values,
then repeat paste special and select column width



--


Regards,


Peo Sjoblom



"JR Hester" wrote in message
...
Is there any way to copy data from one shhet to another AND have the
column
width/row hieght trasfer as well? I am accustomed to using paste special,
but
this seem sNOT to include col width and row hieght.

Any way to accomplish without VBA?

Thanks