|
本帖最后由 sanbe 于 2011-7-20 23:08 编辑
- Private Sub CommandButton1_Click()
- Dim irow%, i%
- irow = Sheet1.[a65536].End(xlUp).Row
- For i = 1 To irow
- Cells(1, 5) = Sheet1.Cells(i, 1)
- LastSub (2)
- Next
- MsgBox "Done!"
- End Sub
复制代码
- Private Sub CommandButton1_Click()
- Dim irow%, i%
- irow = Sheet1.[a65536].End(xlUp).Row
- For i = 1 To irow
- Cells(1, 5) = Sheet1.Cells(i, 1)
- LastSub (7200)
- Next
- MsgBox "Done!"
- End Sub
- Public Function LastSub(ByRef LastTime As Double) As Boolean
- Dim loopfinisH
- Dim intI As Integer
- Const SecondsInday = 24& * 60& * 60
- loopfinisH = Timer + LastTime
- intI = intI + 1
- If loopfinisH > SecondsInday Then
- loopfinisH = loopfinisH - SecondsInday
- Do While Timer > loopfinisH
- DoEvents
- LastSub = False
- Loop
- End If
- Do While Timer < loopfinisH
- DoEvents
- LastSub = False
- Loop
- LastSub = True
- End Function
复制代码 |
|