Good to hear.

I was about to reply with a few questions........my style<g

But now I don't have to.

Curious to know what happened in the half hour between "it didn't work" to "it
works"

Most likely pasting to the wrong sheet??


Gord

On Mon, 10 Mar 2008 13:09:01 -0700, Astroboy
wrote:

Oh... it works.... and thank you~~~!!!!!!!!!!!!!!!!!!!!

"Gord Dibben" wrote:

Copy/paste this into the sheet module of your Template.xls

Private Sub Worksheet_Change(ByVal Target As Range)
'retain formatting when a cell is copied over
Dim myValue
With Application
.EnableEvents = False
myValue = Target.Value
.Undo
Target = myValue
Application.CutCopyMode = False
.EnableEvents = True
End With
End Sub


Gord Dibben MS Excel MVP

On Mon, 10 Mar 2008 04:14:12 -0700, Astroboy
wrote:

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