Excel vba删除无填充颜色单元列 1、b2:X5区域 2、这区域内某列某单元格有填
答案:1 悬赏:80
解决时间 2021-02-19 04:21
- 提问者网友:欺烟
- 2021-02-18 23:52
Excel vba删除无填充颜色单元列 1、b2:X5区域 2、这区域内某列某单元格有填
最佳答案
- 二级知识专家网友:轮獄道
- 2021-02-19 01:02
程序如下:
Sub 宏()
Dim i As Integer, j As Integer, k As Integer
For i = 2 To 24
k = 0
For j = 2 To 5
If Cells(j, i).Interior.ColorIndex <> -4142 Then
k = k + 1
End If
Next
If k = 0 Then
Range(Cells(2, i), Cells(5, i)).Select
Selection.ClearContents
End If
Next
End Sub
Sub 宏()
Dim i As Integer, j As Integer, k As Integer
For i = 2 To 24
k = 0
For j = 2 To 5
If Cells(j, i).Interior.ColorIndex <> -4142 Then
k = k + 1
End If
Next
If k = 0 Then
Range(Cells(2, i), Cells(5, i)).Select
Selection.ClearContents
End If
Next
End Sub
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯
• 手机登qq时,显示手机磁盘不足,清理后重新登 |
• 刺客的套装怎么选啊? |