--Copy range
--Select the target cell and right click PasteSpecialAllOK
--Keeping the target selection right clickPasteSpecialselect ColumnWidthOK

If this post helps click Yes
---------------
Jacob Skaria


"Emece" wrote:

In Sheet 1 I have a certain amount of data, I want to select some cells and
copy them to Sheet 2 keeping the same format. When I do this, the fonts and
the colours remain unchanged, but the column width don't. I have tried paste
special, but couldn't figure it out. Is this possible?

Thanks in advance

Regards,
Emece.-