(Solved) – How to use the same macro for a new row

  • by
(solved)-–-how-to-use-the-same-macro-for-a-new-row

How do I change the following code to use the same macro for the next row in my spreadsheet: i.e. range(“C1360”) then “C1361” etc.

ActiveWindow.ActivateNext
Range("C1359").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False

Leave a Reply

Your email address will not be published. Required fields are marked *