|
本帖最后由 happy1117 于 2013-4-1 23:43 编辑
老师们,帮忙优化代码让它运行
Sub 日期比较()
Dim Ar(), R As Long, D
D = Worksheets("Sheet1").Range("h1").Value (这里要怎么改呢,现在提示下标越界)
R = Range("B65536").End(xlUp).Row
ReDim Ar(1 To R, 1)
Ar = Range("B2:B" & R)
For i = 1 To UBound(Ar)
R = Abs(DateDiff("M", D, Ar(i, 1)))
Select Case R
Case 0 To 2
Ar(i, 1) = "3个月以内"
Case 3 To 5
Ar(i, 1) = "4-6个月"
Case 6 To 8
Ar(i, 1) = "7-9个月"
Case 9 To 11
Ar(i, 1) = "10-12个月"
Case Else
Ar(i, 1) = "一年以上"
End Select
Next
Columns("D").Insert
Range("D2").Resize(UBound(Ar)) = Ar
End Sub
|
|