|
本帖最后由 qq8945051 于 2014-7-24 10:20 编辑
有老大知道 怎么用VBA 选中 sheet1中 所有含有张三,李四,王五的单元格 注意是 选中所有含有
有办法实现么
- Sub test() '风林火山
- Dim rng As Range, rg As Range, ranges As Range, arr
- arr = Array("张三", "李四", "王五")
- Set ranges = Sheet1.UsedRange
- For Each rg In ranges
- For k = 0 To UBound(arr) - 1
- If arr(k) Like rg Then
- If rng Is Nothing Then
- Set rng = rg
- Else
- Set rng = Union(rng, rg)
- End If
- Exit For
- End If
- Next
- Next
- rng.Select
- End Sub
复制代码
|
|