View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
slocookie slocookie is offline
external usenet poster
 
Posts: 1
Default Copy worksheet1 to worksheet2, keep cell format eg cell size

I want to copy information from worksheet 1 to worksheet 2. I copy the
information in H1 and the size of the cell conforms to the size of the row.
Is there a way to paste in the info, and keep the worksheets' formats separte?