I created a macro to copy and paste the formulas from one row to
another. I dont want to copy the the values.
When I run it, it copys the formulas but ALSO the values. What am i
doing wrong? Can someone help me?

-------------------------------------------------------------------------
Application.Goto Reference:="totaal"
Selection.EntireRow.Insert
Application.Goto Reference:="totaal"
ActiveCell.Offset(-2, -35).Range("A1:AJ1").Select

Selection.Copy
Application.Goto Reference:="totaal"
ActiveCell.Offset(-1, -35).Range("A1:AJ1").Select

Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

--------------------------------------------------------------------------


---
Message posted from http://www.ExcelForum.com/