[算表] VBA 大量資料處理
軟體:Excel
版本:2010
i=2
Do
If XXX then
J=2
Do
IF XXX then
Exit Do
End IF
J=J+1
Loop Until len(Worksheets("工作表2").Cells(J,1).Value)=0
End If
I=I+1
Loop Until len(Worksheets("工作表1").Cells(I,1).Value)=0
工作表1,2皆有近2萬筆
每次都跑到當掉，請問這有解嗎??
除了把資料導入資料庫以外
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 59.120.143.229
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1505440814.A.8FB.html
→
09/15 10:52, , 1F
09/15 10:52, 1F
→
09/15 10:52, , 2F
09/15 10:52, 2F
→
09/15 10:52, , 3F
09/15 10:52, 3F
→
09/15 10:52, , 4F
09/15 10:52, 4F
→
09/15 10:52, , 5F
09/15 10:52, 5F
→
09/15 10:52, , 6F
09/15 10:52, 6F
→
09/15 10:53, , 7F
09/15 10:53, 7F
→
09/15 10:53, , 8F
09/15 10:53, 8F
→
09/15 10:55, , 9F
09/15 10:55, 9F
推
09/16 12:39, , 10F
09/16 12:39, 10F
→
09/16 12:39, , 11F
09/16 12:39, 11F
→
09/16 13:10, , 12F
09/16 13:10, 12F
→
09/16 13:12, , 13F
09/16 13:12, 13F
推
09/16 21:45, , 14F
09/16 21:45, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章