I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. It should always go to the next row, but I can't get it to do it. Here's what I have: Any help?
' Macro7 Macro
' Macro recorded 04/02/2009 by Farmland Foods, Inc.
' Keyboard Shortcut: Ctrl+q
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Application.CutCopyMode = False