software

Whenever I copy a worksheet to a new page, I have to reset the column widths,
Bold selections, alignments, etc. How do I copy so that the non-text
material appears at the destination? quot;Paste specialquot; doesn't help. Thanks
Peg

Hi Peg,

Why does PasteSpecial not help?? Seems it has everything you're asking for.
:?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.quot;Pegquot; gt; wrote in message
news
gt; Whenever I copy a worksheet to a new page, I have to reset the column
gt; widths,
gt; Bold selections, alignments, etc. How do I copy so that the non-text
gt; material appears at the destination? quot;Paste specialquot; doesn't help.
gt; Thanks
gt; Peg
You can copy a worksheet just by CTRL-drag in the same workbook window
- you then have an identical sheet, including column widths and all
formatting.

Hope this helps.

Pete