excel - 插入行和填充的宏失败

Question

我编写了以下宏以将指定数量的行插入表中，然后进行填充，以使用正确的论坛重新填充表。

我不知道为什么这会在 ActiveSheet.Rows(r).Insert 出现错误并出现运行时错误 1004。 Range 类的 Insert 方法失败。

你能帮帮我吗？

Sub SetKPIDuration()

Dim Duration As Integer, i As Integer, r As Integer

Duration = InputBox("Enter number of week for KPI to run (min 18)", 
"Duration of KPI", 18)

Select Case True
    Case Duration < 10
        Duration = 18
        GoTo IncreaseKPI
    Case Duration < Application.WorksheetFunction.Max(Range("A7:A150"))
        GoTo ReduceKPI
    Case Else
        GoTo IncreaseKPI
End Select

ReduceKPI:

Rows((Duration + 7) & ":150").Clear
Exit Sub

IncreaseKPI:
Application.ScreenUpdating = False
i = Application.WorksheetFunction.Max(Range("A7:A150"))
r = i + 7

While i < Duration

    ActiveSheet.Rows(r).insert

Wend

Range("A" & (r - 1) & ":" & "M" & (r + i)).filldown


Application.CutCopyMode = False


ScreenUpdating = True

End Sub

Answer 1

尝试使用完整的 workbooks.worksheets.range 路径完全限定您的范围。