- Sub test()
- Dim arr, arrt(), i%, n$
- arr = Range("b8:e" & [b65536].End(3).Row)
- ReDim arrt(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- n = Mid(arr(i, 1), InStr(1, arr(i, 1), "年度") - 4, 4)
- arrt(i, 1) = Replace(arr(i, 2), ".htm", "-" & n & "-<1," & arr(i, 4) & ",1,False,False>.htm")
- Next
- Range("f:f").ClearContents
- [f8].Resize(UBound(arrt), 1) = arrt
- End Sub
复制代码 |