- Sub test()
- Dim m, x
- Dim arr(1 To 1, 1 To 12)
- m = Application.Match(Range("i6"), Range("k6:v6"), 0)
- For x = m To 12
- k = k + 1
- arr(1, x) = Mid("甲乙丙丁戊己庚辛壬癸", k, 1)
- Next x
- For x = 1 To m - 3
- k = k + 1
- arr(1, x) = Mid("甲乙丙丁戊己庚辛壬癸", k, 1)
- Next x
- Range("k5").Resize(1, 12) = arr
- End Sub
复制代码
Book1.rar
(12.1 KB, 下载次数: 9)
|