|
A学委:qushui- Sub 第一题_单击()
- Dim rg1 As Range, rg2 As Range, f As String, x As Integer
- With Sheets("第一题")
- .Range(.Cells(1, 2), .Cells(10, 50)).Clear
- Set rg1 = .Columns(1).Find(what:="A", after:=.[a1], Lookat:=xlWhole, MatchCase:=True)
- f = rg1.Address
- x = 1
- Do
- x = x + 1
- Set rg2 = .Columns(1).FindNext(rg1)
- If rg2.Address <> f Then
- .Range(rg1, rg2.Offset(-1, 0)).Copy .Cells(1, x)
- Set rg1 = rg2
- Else
- .Range(rg1, .[a65536].End(3)).Copy .Cells(1, x)
- End If
- Loop Until rg2.Address = f
- End With
- End Sub
- [code]Sub 第二题_单击()
- Dim m%, n%, i%
- Application.DisplayAlerts = False
- With Sheets("第二题")
- m = 2
- For i = 2 To .[a65536].End(3).Row - 1
- If .Cells(i + 1, 1) <> "" And .Cells(i, 1) <> .Cells(i + 1, 1) Then
- n = i
- If .Range(.Cells(m, 1), .Cells(n, 1)).MergeCells Then
- .Range(.Cells(m, 1), .Cells(n, 1)).UnMerge
- .Range(.Cells(m, 1), .Cells(n, 1)) = .Cells(m, 1).Value
- Else
- .Range(.Cells(m, 1), .Cells(n, 1)).Merge
- End If
- m = i + 1
- End If
- If i = .[a65536].End(3).Row - 1 Then
- If .Cells(m, 1).MergeArea.Address <> .Cells(m, 1).Address Then
- .Cells(m, 1).MergeArea.Select
- Selection.UnMerge
- Selection = .Cells(m, 1).Value
- Else
- .Range(.Cells(m, 1), .[a65536].End(3)).Merge
- End If
- End If
- Next i
- End With
- Application.DisplayAlerts = True
- End Sub
复制代码 [/code] |
|