|
本帖最后由 FredericHo 于 2022-10-27 09:48 编辑
运行错误,自动退出EXCEL,麻烦大神帮忙看一下Private Sub Worksheet_Change(ByVal Target As Range)
Dim h
h = Target.Row
If Target.Row > 10 And Target.Row < 16 And Cells(h, 13) <> 0 Then
Cells(h, 11) = Cells(h, 13) / Cells(h, 12)
Else
Cells(h, 13) = Cells(h, 11) * Cells(h, 12)
End If
End Sub
|
|