Sub Click()
Dim A$(1 To 180, 1 To 6), i%, j%, s%, str$
str = "赛维抽奖券"
For i = 1 To UBound(A)
For j = 1 To UBound(A, 2)
If i Mod 2 Then
A(i, j) = str
Else
s = s + 1
A(i, j) = Format(s, "000")
End If
Next j
Next i
With Sheet2
.Cells.Clear
.Range("a1").Resize(i - 1, j - 1) = A
.Activate
End With
End Sub
赛维抽奖券2.rar
(619.07 KB, 下载次数: 27)