|
这个代码能不能帮我看下,
复制多行内容到D E F列。G列得不到更新
请问代码,怎么写,谢谢
还有复制的行数是个变量,可能是一行,二行,几千行…………
不管在D E F 列复制多少行,G列都能得到对应的值。。。
弄了好久,都没实现,特到贵地来求助各位,谢谢!!! 看起来有点累,水平有限 。.以前用的是SUM函数,但数据太多,拖累文档。所以想用VBA。
- Private Sub Worksheet_Change(ByVal Target As Range)
- 'If Target.Count > 1 Then Exit Sub
- If Target.Row < 11 Then Exit Sub
- If Target.Column = Columns("D").Column And Target.Rows.Count = 1 Then
- ActiveSheet.Cells(Target.Row, Columns("G").Column) = Round(Target * Target.Offset(0, 1) * Target.Offset(0, 2) * 0.000001, 2)
- 'If Target.Column = Columns("D").Column And Target.Rows.Count <> 1 Then 这下面应该怎么写,谢谢!基础不好呀
- ElseIf Target.Column = Columns("E").Column And Target.Rows.Count = 1 Then
- ActiveSheet.Cells(Target.Row, Columns("G").Column) = Round(Target * Target.Offset(0, -1) * Target.Offset(0, 1) * 0.000001, 2)
- ElseIf Target.Column = Columns("F").Column And Target.Rows.Count = 1 Then
- ActiveSheet.Cells(Target.Row, Columns("G").Column) = Round(Target * Target.Offset(0, -1) * Target.Offset(0, -2) * 0.000001, 2)
- End If
- If ActiveSheet.Cells(Target.Row, Columns("G").Column).Value < 0.2 Then
- ActiveSheet.Cells(Target.Row, Columns("G").Column).Value = 0.2
- End If
- End Sub
复制代码
|
|