|
- Private Sub CommandButton1_Click() '创建命令按钮过程
- Dim arr, j%, d As Object '声明数组,变量及字典
- Set d = CreateObject("scripting.dictionary") '创建字典引用
- arr = Range(Cells(3, 1), Cells(3, [iv3].End(1).Column)) '将一个单元格多行的区域赋值给二维数组
- For j = 1 To UBound(arr, 2) '从二维数组第一列循环至最后一列
- d(j) = Split(arr(1, j), Chr(10)) '将数组元素用换行符分隔成一维数组后赋值给字典的KEY
- Next j '继续循环
- [a7].Resize(UBound(Split(arr(1, 1), Chr(10))) + 1, UBound(arr, 2)) = Application.Transpose(d.items)
- '将A7单元格调整大小至行数与单元格内行数相同,列数与数组列数相同的单元格区域,放入字典KEY
- End Sub
复制代码 |
|