Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As String
i = Sheet1.[B2].Value
On Error Resume Next
Application.EnableEvents = False
For Each c In Target.Cells
With c
If .Column >= 4 And .Column <= 7 And .Row = 2 Then .Value = .Value * i
End With
Next
Application.EnableEvents = True
End Sub
现在可以使指定的区域里输入数值,乘以一个倍数,然后显示;
我想让每一行都乘以一个不同的倍数,我只会本方法,就是多定义变量,然后If .Column >= 4 And .Column <= 7 And .Row = 2 Then .Value = .Value * i 《==把变量换过来换过去,这也太笨了点,我想请问有没有比较简洁的方法,谢谢