EXCEL运行宏程序时出现: 方法'_Default作用于对象'Range'时失败
程序如下:PrivateSubWorksheet_Change(ByValTargetAsRange)IfCells(8,6)="轿门整组"AndCells(8,1)="...
程序如下:
Private Sub Worksheet_Change(ByVal Target As Range)
If Cells(8, 6) = "轿门整组" And Cells(8, 1) = "中分2扇" And (Cells(31, 7) - Cells(8, 5) > 0 And Cells(31, 7) - Cells(8, 5) <= 335) And (2 * Cells(8, 3) + 100) < Cells(8, 5) + 130 Then
Cells(8, 9) = Cells(8, 5) + 130 -----------在这行会出现问题!!!
End If
End Sub
然后就会出现 要求调试的界面,若强制关闭的话会出现:系统内存不足,无法完全显示 展开
Private Sub Worksheet_Change(ByVal Target As Range)
If Cells(8, 6) = "轿门整组" And Cells(8, 1) = "中分2扇" And (Cells(31, 7) - Cells(8, 5) > 0 And Cells(31, 7) - Cells(8, 5) <= 335) And (2 * Cells(8, 3) + 100) < Cells(8, 5) + 130 Then
Cells(8, 9) = Cells(8, 5) + 130 -----------在这行会出现问题!!!
End If
End Sub
然后就会出现 要求调试的界面,若强制关闭的话会出现:系统内存不足,无法完全显示 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询