有时候,我们可以用VBA操作单元格,比如,用VBA代码将数组内容批理写入单元格:
Sub arrtorng2() Dim arr(1 To 2, 1 To 3) As String arr(1, 1) = 1 arr(1, 2) = "黑白鱼" arr(1, 3) = "男" arr(2, 1) = 2 arr(2, 2) = "小燕" arr(2, 3) = "女" Range("A1:C2").Value = arr '将数组批量写入单元格区域 End Sub效果自己试试!(打开Excel,按下ALT+F11)
已有 0/10244 人参与