|
楼主 |
发表于 2021-1-18 20:41
|
显示全部楼层
不懂就是不懂,还是要到这里来问高手
换一个EXCEL文件后,直接复制粘贴 A1233515 写的 宏代码 不知道怎样才能实现,请高手指教
Sub fuzhi()
Dim arr, brr, rng As Range, i&, k&, m&, n&
Dim p&
i = Sheet1.UsedRange.Rows.Count
ReDim arr(1 To i / 2)
ReDim brr(1 To i / 2)
For Each rng In Sheet1.Range("a1:a" & i)
If rng.Interior.Color = RGB(255, 255, 0) Then
k = k + 1
If Int(k / 2) = k / 2 Then
m = m + 1
brr(m) = rng.Row
Else
n = n + 1
arr(n) = rng.Row
End If
End If
Next
Worksheets.Add after:=Sheets(1)
ActiveSheet.Name = "复制1121"
Sheet1.Range("1:1").Copy ActiveSheet.Range("a1")
For p = 1 To UBound(arr)
If arr(p) <> "" And brr(p) <> "" Then
Sheet1.Range(arr(p) & ":" & brr(p)).Copy ActiveSheet.Range("a" & Rows.Count).End(xlUp).Offset(1, 0)
End If
Next
End Sub
|
|