How to copy cell formats from a sheet

[Barcode]

In a macro, I am copying data from another sheet and most of the time I only require the actual data or the values as per below.

Please Login or Register  to view this content.

But sometimes I want to also copy the Formats of the cell eg. color etc.
How do I go about doing this please?

[JBeaucaire]

To get the full cell to copy would require going to two lines of code:

Please Login or Register  to view this content.

This would copy formulas instead of values, though. There are many options to the PASTESPECIAL, you can try them all to see if any of them give you the exact behavior you want:

Please Login or Register  to view this content.

Perhaps it would be a combination of more than one...

[Barcode]

Thanks JB, much appreciated