On Sun, 21 Nov 2004 04:19:21 -0800, "keepITcool" wrote:

maybe my steps were not clear?

Sub ReproBug()

With Range("a1:e1")
.Clear
.Value = Array(1, 2, 3, 4, "=sum(a1:d1)")
With .Cells(1).Resize(, 2)
.Merge
.Copy
End With
.Cells(3).PasteSpecial xlFormats
End With

End Sub

gives me : 1 merge warning and 8 in e1
(xl97,xlXP,xl2003)

See my later response to Jerry. With your initial operation, and with the SUB,
after completing your steps, if I then hit <esc (and not <enter or <paste),
then I can reproduce your feature.

Also, using the format painter in a single operation will reproduce the
problem. If you use it for a multiple operation (i.e. double click on the
format painter), then you have the opportunity to hit <enter and get the
merge.

HOWEVER, and this would seem to be ANOTHER bug, if you do the PASTE FORMAT on a
merged cell, and if you hit <enter or <paste when done, C1:D1 do merge, but
the VALUE from A1 gets copied over into C1.




--ron