View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Copy Excel Sheet to another sheet and preserve formatting?

How do you copy an Excel sheet to another sheet - or create a new worksheet
and use the same formatting as another sheet? Like sheet 1 columns A-M are
..5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the
formatting in sheet1?

Thanks,
Rich