|
发表于 2014-1-14 08:46
|
显示全部楼层
本楼为最佳答案
楼主所说的宏运行时先清空内容是其他宏还是这个宏?如果是其他宏,可以用工作表事件:- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Column > 2 Then Exit Sub
- If Target.Row <> 1 Then Exit Sub
- If Target.Column = 1 Then
- If Target <> "" And Target.Offset(0, 1) <> "" Then
- Target.Offset(0, 2) = Target + Target.Offset(0, 1)
- Else
- Target.Offset(0, 2) = ""
- End If
- Else
- If Target <> "" And Target.Offset(0, -1) <> "" Then
- Target.Offset(0, 1) = Target + Target.Offset(0, -1)
- Else
- Target.Offset(0, 1) = ""
- End If
- End If
- End Sub
复制代码 |
|