Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r = 1 And Target.Count = 1 Then
' MsgBox Range(Cells(2, c), Cells(2, c).End(xlDown)).Address
Range(Cells(2, c), Cells(2, c).End(xlDown)).Copy
End If
End Sub 点击复制问题2.rar(246.83 KB, 下载次数: 10)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r = 1 And Target.Count = 1 Then
' MsgBox Range(Cells(2, c), Cells(2, c).End(xlDown)).Address
Range(Cells(2, c), Cells(2, c).End(xlDown)).Copy
End If
End Sub 点击复制问题2.rar(246.83 KB, 下载次数: 10)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r = 1 And Target.Count = 1 Then
Application.ScreenUpdating = False
Rows("2:21").RowHeight = 13.5
Range(Cells(2, c), Cells(2, c).End(xlDown)).Copy
Rows("2:21").RowHeight = 0
Application.CutCopyMode = 0
End If
End Sub