Apr 2, 2009 at 11:30 AM
Posts3Registration dateFriday December 4, 2015StatusMemberLast seenDecember 4, 2015
Dec 4, 2015 at 10:30 AM
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