|
如何将以下二个代码合成一个代码,求高手指点!
一:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Integer, j As Integer
i = 1
For j = 2 To 5 Step 1
If Target.Row = 1 Then
Exit Sub
ElseIf Target.Column = j Then
If Target.Cells <> "" And Cells(Target.Row, j + 4) = "" Then
Cells(Target.Row, j + 4) = Sheet2.Cells(11, j)
End If
End If
Next j
End Sub
二:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 Or Target.Column <> 3 Then Exit Sub
If Target.Cells <> "" And Cells(Target.Row, 1) = "" Then
Cells(Target.Row, 1) = Date
End If
End Sub
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim i As Integer, j As Integer
- i = 1
- For j = 2 To 5 Step 1
- If Target.Row = 1 Then
- Exit Sub
- ElseIf Target.Column = j Then
- If Target.Cells <> "" And Cells(Target.Row, j + 4) = "" Then
- Cells(Target.Row, j + 4) = Sheet2.Cells(11, j)
- End If
- End If
- Next j
- If Target.Row = 1 Or Target.Column <> 3 Then Exit Sub
- If Target.Cells <> "" And Cells(Target.Row, 1) = "" Then
- Cells(Target.Row, 1) = Date
- End If
- End Sub
复制代码
|
|