我在自己看VBA入门,下边一段代码在执行时会报错,我不知道错在哪里,请各位老师帮忙指教,多谢!!! Private Sub Worksheet_Change(ByVal Target As Range) Dim mrow As Integer Dim brng As String Dim crng As String mrow = Target.Row If Len(Range("B" & mrow)) > 0 And Len(Range("C" & mrow)) > 0 Then Target.Column >1 And Target.Column < 4 brng = Range("b" & mrow).Address(0, 0) crng = Range("c" & mrow).Address(0, 0) Range("d" & mrow).Formula = "=" & brng & "-" & crng End If End Sub
[此贴子已经被作者于2010-5-17 17:40:44编辑过]
Private Sub Worksheet_Change(ByVal Target As Range) Dim mrow As Integer mrow = Target.Row If Target.Count > 1 Then End If Len(Range("B" & mrow)) > 0 And Len(Range("C" & mrow)) > 0 Then Cells(mrow, 4) = Cells(mrow, 2) - Cells(mrow, 3) Else Cells(mrow, 4) = "" End If End Sub
|