When Your copying data using current Region How can you copy the format also?

[swade730]

Hi,

basically I have a code that copys whats on a worksheet...

Please Login or Register  to view this content.

But there is a format to the area and when I paste it to the work book Im sending it to, the data carries over but not the formatting.

How can I get the formatting over using Current region?
Below, is what Im doing to paste, which results in the data and not the format coming over.

Please Login or Register  to view this content.

[stnkynts]

You do realize that PasteValues will only paste the values, not the format.

Did you try xlPasteAll?

Also, why are you using current region in this situation?

[swade730]

You do realize that PasteValues will only paste the values, not the format.

Did you try xlPasteAll?

DER DA DERRRR

-Thanks

marking as solved....