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