Macro Match Destination formatting

[thejacko5]

Hey all, if i have a macro that is copying something from one sheet to another, and each sheet has different formatting, how can I make the pasted data match the destination formatting

[Bob Phillips]

Worksheets("Sheet1").Range("A1:e5").Copy
Worksheets("Sheet2").Range("C2").PasteSpecial Paste:=xlPasteValues