Hi slocookie,

Have you tried Paste special? Copy then at H1 right click then select paste
special, then values.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


"slocookie" wrote:

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?