Is there a way to copy and paste from a formatted set of cells, to an
unformatted set and have the formatting copy/paste as well, so that
column/row sizes adjust to be the same?

Thanks

Steven Shelton

"Those who hammer their guns into plows will plow for those who
do not!" --Thomas Jefferson

Hi Steven

With pastespecial you can also copy column width but not row height
See the edit menu for PasteSpecial

If you only want to copy a range to another place to view/print then you can try this
Row and column width is working then
http://www.rondebruin.nl/print.htm#non-contiguous


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steven" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Is there a way to copy and paste from a formatted set of cells, to an
> unformatted set and have the formatting copy/paste as well, so that
> column/row sizes adjust to be the same?
>
> Thanks
>
> Steven Shelton
>
> "Those who hammer their guns into plows will plow for those who
> do not!" --Thomas Jefferson
>
>
>