How do I copy pages so that formats also arrive at the destinatio

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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? "Paste special" doesn't help. Thanks
Peg
 
Hi Peg,

Why does PasteSpecial not help?? Seems it has everything you're asking for.
:?
 
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
 
Back
Top