3282| 2
|
VBA查询指定区域包含指定字符的单元格并输出 |
1学分
最佳答案你这横向查询有点奇怪,我还是按照横向的模式做的:
s = Range("a2")
hs = 3
For i = 12 To Worksheets("Total-06").[l5].End(2).Column
If InStr(Worksheets("Total-06").Cells(5, i), s) > 0 Then
Cells(hs, 1) = Worksheets("Total-06").Cells(5, i)
hs = hs + 1
End If
Next i
| ||
发表于 2020-6-22 15:19
|
显示全部楼层
| |
| ||