|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub TEST1()
Dim ar, br, i&, j&, r&
ar = [A1].CurrentRegion.Value
ReDim br(1 To UBound(ar) * UBound(ar, 2), 1 To 2)
br(1, 1) = "班级": br(1, 2) = "姓名": r = 1
For i = 2 To UBound(ar)
For j = 2 To UBound(ar, 2)
r = r + 1
br(r, 1) = ar(i, 1)
br(r, 2) = ar(i, j)
Next j
Next i
[J1].CurrentRegion.Clear
With Range("J1:K" & r)
.Value = br
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Borders.LineStyle = xlContinuous
End With
Beep
End Sub |
|