本帖最后由 冥王 于 2015-9-6 14:51 编辑
代码倒数第二行[O2] 表示查找结果写入到以O2为左上角的单元格区域,这里可以手动修改,或者- Sub demo()
- Dim fStr$, i%, arr(1 To 9999, 1 To 1)
- Dim rng As Range, r As Range
- On Error Resume Next
- fStr = "孙悟空"
- For Each rng In ActiveSheet.UsedRange
- If rng = fStr Then
- i = i + 1
- arr(i, 1) = rng.Address(0, 0)
- End If
- Next
- Set r = Application.InputBox("请选择结果要写入的单元格顶点", "选择单元格", "O2", , , , , 8)
- r.Resize(i, 1) = arr
- End Sub
复制代码 |