- Sub demo()
- On Error Resume Next
- Dim myStr1$, myStr2$, iStr$, i%, arr, crr(), drr()
- With Sheets(1)
- arr = .Range("E2:H" & .Range("E2").End(xlDown).Row)
- ReDim crr(1 To 1, 1 To UBound(arr, 1))
- ReDim drr(1 To 1, 1 To UBound(arr, 1))
- For i = LBound(arr, 1) To UBound(arr, 1)
- myStr1 = arr(i, 1)
- myStr2 = arr(i, 3)
- iStr = Replace(myStr1, "播放:", "")
- If Right(iStr, 1) = "万" Then
- crr(1, i) = Left(iStr, Len(iStr) - 1) * 10000
- Else
- crr(1, i) = CLng(iStr)
- End If
- drr(1, i) = arr(i, 4) & Replace(Mid(myStr2, InStrRev(myStr2, "/") + 1, 999), ".html", "")
- Next
- Range("E20").Resize(UBound(arr), 1) = Application.Transpose(crr) '测试没问题的话修改单元格写入地址,下同
- Range("I20").Resize(UBound(arr), 1) = Application.Transpose(drr)
- End With
- End Sub
复制代码 |