Try to use PasteSpecial/Values instead of Paste! Paste copies values and
formats as well.

Regards,
Stefi


€žAstroboy€� ezt Ã*rta:

Hello....

I have worksheet call Template.xls with format I like to use..(bold.. align
center..borders..etc.....)

But whenever I copy cells from another worksheet and paste on Template.xls
then my format is gone..(NO bold, align center...etc..)

So my question is ... is there any way to keeping my format? even though I
copy and paste from another wokrsheet...

Thanks in advance...