|
发表于 2014-10-30 10:32
|
显示全部楼层
本楼为最佳答案
这个问题我也碰到过end方法返回的始终不对。- Sub dybc()
- Dim a, b, c As Integer
- Dim v As Variant
- Dim t As String
- Application.ScreenUpdating = False
- a = 5
- Do While Len(Sheet2.Range("b" & a).Value)
- a = a + 1
- Loop
- a = a - 1
- ' If Sheet2.[B13] = "" Then
- ' a = Sheet2.[B13].End(xlUp).Row
- ' Else
- ' a = 13
- ' End If
- v = Sheet2.Range("B5:G" & a).Value
- With Sheet9
- b = .[D65536].End(xlUp).Row + 1
- .Range("E" & b & ":J" & b + a - 5).Value = v
- t = .Range("B" & b - 1)
- If Format(Date, "yyyy-m-d") = t Then
- c = Val(Right(.Range("C" & b - 1), 3)) + 1
- Else
- c = 1
- End If
- Sheet2.Range("B17 ") = "No." & Format(Date, "yyyymmdd") & Format(c, "000")
- .Range("C" & b & ":C" & b + a - 5) = "No." & Format(Date, "yyyymmdd") & Format(c, "000")
- .Range("B" & b & ":B" & b + a - 5) = Format(Date, "yyyy-m-d")
- .Range("D" & b & ":D" & b + a - 5) = Sheet2.Range("E17")
- .Range("K" & b).Value = Sheet2.Range("E14").Value
- .Range("L" & b).Value = Sheet2.Range("D16").Value
- .Range("K" & b & ":K" & b + a - 5).Merge
- .Range("L" & b & ":L" & b + a - 5).Merge
- End With
- Sheet2.PrintOut
- Application.ScreenUpdating = True
- End Sub
复制代码 用笨方法来判断的。 |
|