Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r_ren%, i%, arr
r_end = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
arr = Range("a1:e" & r_end)
If Target.Column = 3 Then
For i = 1 To r_end
arr(i, 3) = arr(i, 1) * arr(i, 2)
If arr(i, 3) = 0 Then
arr(i, 3) = ""
End If
Next i
[a1].Resize(r_end, 3) = arr
End If
If Target.Column = 5 Then
For i = 1 To r_end
If arr(i, 3) <> 0 Then
arr(i, 5) = arr(i, 3) * arr(i, 4)
If arr(i, 5) = 0 Then
arr(i, 5) = ""
End If
End If
Next i
[a1].Resize(r_end, 5) = arr
End If
End Sub