|
- Sub yy()
- Dim Arr, i&, r%, Arr1(), ks, js, lt, tp
- Application.DisplayAlerts = False
- Sheet1.Activate
- Arr = [a1].CurrentRegion
- For i = 2 To UBound(Arr)
- If Arr(i, 1) <> Arr(i - 1, 1) Then
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- Arr1(r) = i
- End If
- Next
- For i = 1 To r
- If i <> r Then
- js = Arr1(i + 1) - 1
- Else
- js = UBound(Arr)
- End If
- ks = Arr1(i)
- Cells(ks, 1).Resize(js - ks + 1).Merge
- Cells(ks, 2).Resize(js - ks + 1).Merge
- lt = Cells(js, 3).Left
- tp = Cells(js, 3).Top
- ActiveSheet.Buttons.Add(lt, tp, 84, 26.25).Select
- Selection.OnAction = "dy" & i
- Selection.Characters.Text = "打印"
- Next
- Application.DisplayAlerts = True
- End Sub
复制代码 打印代码请自己加入。 |
|