|
本帖最后由 cunfu2010 于 2017-2-17 09:54 编辑
如题,代码写了一半写不下去了。求帮助。Sub test()
arr = Array("张三", "李四", "王五")
For j = 1 To 15 Step 3
For i = LBound(arr) To UBound(arr)
Next
Next
End Sub
还有,合并单元格,如合并A1、B1、C1
- Sub test()
- Dim i%, j%, arr
- Cells.Clear
- arr = Array("张三", "李四", "王五")
- For j = 1 To 15 Step 3
- For i = LBound(arr) To UBound(arr)
- Cells(i + 1, j) = arr(i) '为当前单元格写入数据
- Cells(i + 1, j).Resize(1, 3).Merge '当前单元格扩展三列进行合并
- Cells(i + 1, j).HorizontalAlignment = xlCenter '合并单元格水平居中
- Next
- Next
- [a1].CurrentRegion.Borders.LineStyle = 1 '添加框线
- End Sub
- Sub qc()
- Cells.Clear
- End Sub
复制代码
|
|