|
要求将表1(sheet"食品企业评定标准")中D栏(标准分值)被红色填充所在行的内容录入表3(扣分说明)中。其中表一A列、B列有合并单元格。
小弟不才写了下代码(已在附件中),感觉没有问题了,但是运行不出来。
求大神赐教,看看哪里出问题了,有新代码欢迎交流。
遇到死循环的话按Ctrl+Break可以强制退出代码运行。
- Sub test()
- Dim i As Long, j As Long, k As Long
- Dim arr, brr(1 To 10000, 1 To 8)
- With Sheets("食品企业评定标准")
- arr = .Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- If arr(i, 1) = "" Then arr(i, 1) = arr(i - 1, 1)
- If arr(i, 2) = "" Then arr(i, 2) = arr(i - 1, 2)
- If .Cells(i, 4).Interior.ColorIndex = 3 Then
- k = k + 1
- For j = 1 To 8
- brr(k, j) = arr(i, j)
- Next
- End If
- Next
- End With
- With Sheets("扣分说明")
- .Range("a2:h65536").Clear
- If k > 0 Then
- With .Range("a2").Resize(k, 8)
- .Value = brr
- .Borders.LineStyle = 1
- .WrapText = True
- .Rows.AutoFit
- End With
- End If
- End With
- End Sub
复制代码
|
|