第1个回答 2013-05-14
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
r = Target.Row
For c1 = 9 To 19
Cells(3, c1).Copy
Cells(r, c1).PasteSpecial
Next c1
Application.CutCopyMode = False
Cells(r, 2).Select
End If
End Sub
就可以了,你试试看本回答被提问者和网友采纳