|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub hz()
Dim ar, br(), i&, k&, m&, Temps, r As Range
ar = Range("A3:L" & Range("a1").CurrentRegion.Rows.Count)
Set r = Range("A3:L" & Range("a1").CurrentRegion.Rows.Count)
ReDim br(1 To Application.CountA(r) + 1, 1 To 1)
br(1, 1) = "教师汇总"
m = 1
For i = 1 To UBound(ar, 2)
For k = 1 To UBound(ar)
Temps = ar(k, i)
If Temps <> "" Then
m = m + 1
br(m, 1) = Temps
End If
Next
Next
[P:P].ClearContents
[P1].Resize(UBound(br)) = br
End Sub
|
|