I recorded this little macro and attached it to a button.

Now when clicking the button all works fine but sometimes I see the function =TODAY() popping up in a cell a few colums to the right where its intended to happen. As far as I can see the data does get replaced in the cell where I want and this popping up is additional. Can anybody spot an error in the code which causes this strange behavior. To be clear the cell in which the date is added by inserting today and than pasting it with value only is a merged cell(most probably not the best but it works for a novice in VBA).

See code below.

Sub IcledonPrice()
'
' IcledonPrice Macro
' Macro recorded 05/03/2010 by Willemv
'
'
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("F6:G6").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.RefreshAll
End Sub