Hello Stefi,

Thank you for reply....

Is Paste Special has HOT Key? Like Paste (ctl-v)? b/c I am using on script
to paste the copied cells...

Thank you....



"Stefi" wrote:

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...