I am trying to write vba to basically copy a row and insert it below the active row with the next number in a sequence. so I would copy a default row and insert it right under the active row and add 1.02 in cell A automatically I just cant figure out where to add the code to this vba or would i have to re-write the code?
Dim ws As Worksheet
Dim rng As Range
If MsgBox("Add a new Line?", vbYesNo, "Confirm") = vbYes Then
Set ws = ThisWorkbook.Sheets("FFE Short")
Set rng = .Rows(ActiveCell.Row)
Application.CutCopyMode = False