[算表] 执行阶段错误"424" 此处需要物件

楼主: appledavid (新三宝:香蕉 鹿茸 太阳饼)   2014-07-24 10:39:27
软件:Office 365
=====================程式码=====================
Sub tesyt()
For i = 1 To 100
sheet1.Cells(i, A) = sheet2.Cells(3, D)
Next
Application.OnTime Now + TimeValue("00:00:03"), "tesyt" 'Counter
End Sub
=========================================================
我想做的功能
我想将Sheet2 D3位置的数字
每三秒放入Sheet1 A Column 放一百个
我哪里做错了? Orz
作者: soyoso (我是耀宗)   2014-07-24 12:03:00

Links booklink

Contact Us: admin [ a t ] ucptt.com