[算表] 儲存格範圍選取問題(左上至右下)
軟體:MS Excel
版本:2007
參考檔案下載連結:
https://drive.google.com/open?id=0B6tYnZny04P0cTAwRUpsTVI0X1U
參考檔案圖片示意:
http://imgur.com/a/tE7Fo
各位前輩好,
目前小弟在練習使用VBA選取範圍,
若使用以下程式碼,
可選取從C1開始算起至右下的連續儲存格範圍,
Range("c1").Resize(Cells(Rows.Count, 3).End(xlUp).Row, 1).Select
Range(Selection, Selection.End(xlToRight)).Select
但是如附檔所示,
G欄,H欄及J欄的儲存格雖含有資料,卻無法被選取.
不知該如何改寫程式碼,
讓程式可以將C1視為選取範圍的最左上角,
往右下選取所有包含值的儲存格範圍,
還望前輩不吝指點迷津,十分感謝.
--
https://www.youtube.com/watch?v=B_CMmbFexbM
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.238.108.169
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1474989486.A.AD2.html
推
09/27 23:21, , 1F
09/27 23:21, 1F
※ 編輯: luckid (36.238.108.169), 09/27/2016 23:33:09
→
09/27 23:32, , 2F
09/27 23:32, 2F
→
09/27 23:34, , 3F
09/27 23:34, 3F
→
09/27 23:34, , 4F
09/27 23:34, 4F
→
09/27 23:35, , 5F
09/27 23:35, 5F
→
09/27 23:35, , 6F
09/27 23:35, 6F
→
09/27 23:37, , 7F
09/27 23:37, 7F
→
09/27 23:54, , 8F
09/27 23:54, 8F
→
09/27 23:58, , 9F
09/27 23:58, 9F
→
09/28 00:00, , 10F
09/28 00:00, 10F
→
09/28 11:24, , 11F
09/28 11:24, 11F
→
09/28 12:53, , 12F
09/28 12:53, 12F
→
09/28 12:54, , 13F
09/28 12:54, 13F
→
09/29 10:24, , 14F
09/29 10:24, 14F