可是sheet1(月报表)编辑器中已经有一组这样的代码了;Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Range("E3").Value >= 1 And Range("E3").Value <= 12 Then If Target.Address = "$E$3" Then Dim i, j As Integer For i = 1 To 2 Range(Cells(5, i * 12 + [E3] - 4), Cells(26, i * 12 + [E3] - 4)).Copy Cells(5, i + 4) Next i Else If ActiveCell.Row >= 5 And ActiveCell.Row <= 26 Then For j = 5 To 26 Select Case Target.Address Case Is = "$E$" & j Range("E" & j).Copy Cells(j, [E3] + 8) Exit For Case Is = "$F$" & j Range("F" & j).Copy Cells(j, [E3] + 20) Exit For End Select Next j End If End If End If End Sub
是不是要在其后重新再加建一组代码吗? |