|
发表于 2013-2-18 18:24
|
显示全部楼层
本楼为最佳答案
- Private Sub Worksheet_Change(ByVal Target As Range)
- On Error Resume Next
- Dim RG As Range
- If Not Application.Intersect(Target, Range("F3:F" & Rows.Count)) Is Nothing Then
- If Target.Count = 1 Then
- Target.Offset(0, -3) = Target.Offset(0, -3) & Target.Value
- Else
- For Each RG In Target
- RG.Offset(0, -3) = RG.Offset(0, -3) & RG.Value
- Next
- End If
- End If
- End Sub
复制代码
ABC (2).rar
(10.56 KB, 下载次数: 7)
|
|