|
- 根据单据编号奇数和偶数判断生成二种不同底色。
- Sub 保存()
- Dim arr(), x&, i&, j&, r&
- x = Application.WorksheetFunction.Max(Range("A7:A12"))
- ReDim arr(1 To x, 1 To 8)
- For i = 1 To x
- arr(i, 1) = Range("f3")
- arr(i, 2) = Date
- arr(i, 3) = Range("b3")
- For j = 2 To 6
- arr(i, j + 2) = Cells(i + 6, j)
- Next
- Next
- With Sheets("成品出库明细")
- MsgBox x
- r = .Range("a65536").End(3).Row + 1
- .Cells(r, 1).Resize(x, 8) = arr
- MsgBox 1 * Right(Range("f3"), 3) Mod 2
-
- If 1 * Right(Range("f3"), 3) Mod 2 = 0 Then '如果末3位是偶数
- '.Cells(r, 1).Resize(x, 8)).Interior.Color = RGB(0, 0, 255) '三基色方法底色蓝色
- .Cells(r, 1).Resize(x, 8).Interior.ColorIndex = 34 '底色浅青色"
- Else
- .Cells(r, 1).Resize(x, 8).Interior.ColorIndex = 24 '底色冰蓝
- End If
- End With
- MsgBox "保存成功!"
- End Sub
复制代码 |
|