Sub a()
Dim k As Integer
k = Worksheets("sheet1").Range("a36656").End(xlUp).Row
Range("d" & h + 1 & "") = Application.WorksheetFunction.SumXMY2(Range("b1:b" & h & ""), Range("c1:c" & h & ""))
End Sub
是这个意思?
Sub a()
Dim k As Integer
k = Worksheets("sheet1").Range("b36656").End(xlUp).Row
Range("d" & k + 1) = Application.WorksheetFunction.SumXMY2(Range("b1:b" & k), Range("c1:c" & k))
End Sub
是这个意思?
Sub a()
Dim k As Integer
k = Worksheets("sheet1").Range("b36656").End(xlUp).Row
Range("d" & k + 1) = Application.WorksheetFunction.SumXMY2(Range("b1:b" & k), Range("c1:c" & k))
End Sub