[問題] excel 自動填滿問題
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體: excel
版本: 2003
Sub 練習()
Sheet1.Select
i = 2
Do
i = i + 1
Loop Until Cells(i, 9) = ""
SheetLen = i - 1
Cells(2, 1).Formula = "=C2&""-""&D2"
Range(Cells(2, 1)).Select
Selection.AutoFill Destination:=Range(Cells(SheetLen, 1))
Cells(1, 1).Select
End Sub
以上程式碼是我練習寫的，但是怎跑都卡在Range(Cells(2, 1)).Select
或是卡到在Selection.AutoFill Destination:=Range(Cells(SheetLen, 1))
然後錯誤碼為1004 global物件失敗?
但是我這是參考寫出來一模一樣查不出錯誤在哪?
需麻煩解答了 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.127.156.65
→
03/23 20:26, , 1F
03/23 20:26, 1F
→
03/23 20:27, , 2F
03/23 20:27, 2F
→
03/23 20:27, , 3F
03/23 20:27, 3F
→
03/23 20:37, , 4F
03/23 20:37, 4F
→
03/23 20:42, , 5F
03/23 20:42, 5F
→
03/23 20:42, , 6F
03/23 20:42, 6F
→
03/23 20:46, , 7F
03/23 20:46, 7F
→
03/23 20:47, , 8F
03/23 20:47, 8F
→
03/23 21:04, , 9F
03/23 21:04, 9F
→
03/23 21:14, , 10F
03/23 21:14, 10F
→
03/23 21:22, , 11F
03/23 21:22, 11F
→
03/23 21:25, , 12F
03/23 21:25, 12F
→
03/23 21:26, , 13F
03/23 21:26, 13F
→
03/23 21:27, , 14F
03/23 21:27, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
