Sub shaixuan()
Dim wkst As Worksheet
For Each wkst In ActiveWorkbook.Sheets
For i = 2 To 26
If Cells(38, i) = 1.3 Or Cells(38, i) = 1.5 Then
Columns(i).EntireColumn.Interior.Color = 3
End If
Next
Next wkst
End Sub
为什么不能实现在workbook内循环呢
少贴了一行
Sub shaixuan()
Dim wkst As Worksheet
Dim i As Integer
For Each wkst In ActiveWorkbook.Sheets
For i = 2 To 26
If Cells(38, i) = 1.3 Or Cells(38, i) = 1.5 Then
Columns(i).EntireColumn.Interior.Color = 3
End If
Next i
Next wkst
End Sub
VBA工作簿循环
答案:1 悬赏:50 手机版
解决时间 2021-02-11 22:35
- 提问者网友:眉目添风霜
- 2021-02-11 16:42
最佳答案
- 五星知识达人网友:孤老序
- 2021-01-13 21:44
Sub shaixuan()
Dim wkst As Worksheet
Dim i As Integer
For Each wkst In ActiveWorkbook.Sheets
For i = 2 To 26
If wkst.Cells(38, i) = 1.3 Or wkst.Cells(38, i) = 1.5 Then
wkst.Columns(i).EntireColumn.Interior.Color = 3
End If
Next i
Next wkst
End Sub
Dim wkst As Worksheet
Dim i As Integer
For Each wkst In ActiveWorkbook.Sheets
For i = 2 To 26
If wkst.Cells(38, i) = 1.3 Or wkst.Cells(38, i) = 1.5 Then
wkst.Columns(i).EntireColumn.Interior.Color = 3
End If
Next i
Next wkst
End Sub
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯