- Sub 插入()
- Dim i&
- Dim myArray(3, 3)
- myArray(0, 0) = "名称": myArray(0, 1) = "a": myArray(0, 2) = "b": myArray(0, 3) = "c":
- myArray(1, 0) = "数据1": myArray(1, 1) = "": myArray(1, 2) = "": myArray(1, 3) = "":
- myArray(2, 0) = "数据2": myArray(2, 1) = "": myArray(2, 2) = "": myArray(2, 3) = "":
- myArray(3, 0) = "数据3": myArray(3, 1) = "": myArray(3, 2) = "": myArray(3, 3) = ""
- i = Cells(Rows.Count, 1).End(xlUp).Row + 1
- If Cells(Rows.Count, 1).End(xlUp).Row + 1 = 2 Then
-
- Range(Cells(i - 1, 1), Cells(i + 2, 4)) = myArray '要移动行列就改cells(i-1,1),行是i-1,列是1就是第一列
- Range(Cells(i - 1, 1), Cells(i - 1, 4)).Interior.Color = RGB(230, 184, 183)
- Range(Cells(i - 1, 1), Cells(i + 2, 1)).Interior.Color = RGB(230, 184, 183)
- Range(Cells(i, 2), Cells(i + 2, 4)).Interior.Color = RGB(218, 238, 243)
- Else
- Range(Cells(i, 1), Cells(i + 3, 4)) = myArray
- Range(Cells(i, 1), Cells(i, 4)).Interior.Color = RGB(230, 184, 183)
- Range(Cells(i, 1), Cells(i + 3, 1)).Interior.Color = RGB(230, 184, 183)
- Range(Cells(i + 1, 2), Cells(i + 3, 4)).Interior.Color = RGB(218, 238, 243)
- End If
- End Sub
复制代码
|