|
本帖最后由 liuts 于 2012-2-15 11:00 编辑
- Sub liuts()
- Dim rng As Range, fsaddress$, ar(10000, 0), k%
- Set rng = Sheet1.Range("d4:ac22").Find(Range("A4").Value)
- If rng Is Nothing Then Range("b4") = "无": Exit Sub
- fsaddress = rng.Address(0, 0)
- Do
- ar(k, 0) = rng.Address(0, 0)
- Set rng = Sheet1.Range("d4:ac22").FindNext(rng)
- k = k + 1
- Loop Until rng.Address(0, 0) = fsaddress
- Range("A7").Resize(k) = ar
- End Sub
复制代码 |
|