Copy and Past keeping the same format

[KIM Chanthan]

Hi,

Do you have any best way to copy and past by keeping the same format?
I mean i want to keep Merge, Color, Number Format....

Please view attached file for example.
Note: I only need copy and past code only!

Thank,

 

[Marc L]

Hi !

Just use Range.Copy method as you can see in VBA inner help
and PasteSpecial method as well or
like you can yet activate the Macro Recorder & operate manually …
​

 

[p45cal]

Range("C2:E2").Copy Range("I2")