[算表] VBA代入某儲存格
軟體: EXCEL
版本:2010
要怎樣才可以使VBA中的某個字由儲存格代入
例如我有個變數I = 1 to 25
後面的25不一定是25
希望可以在某儲存格key in
然後VBA自動帶入那格
這要怎麼做?!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.254.104.182
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1473335913.A.F24.html
推
09/08 20:45, , 1F
09/08 20:45, 1F
推
09/08 20:47, , 2F
09/08 20:47, 2F
→
09/08 22:08, , 3F
09/08 22:08, 3F
→
09/08 22:09, , 4F
09/08 22:09, 4F
→
09/08 22:10, , 5F
09/08 22:10, 5F
→
09/08 22:11, , 6F
09/08 22:11, 6F
→
09/08 22:13, , 7F
09/08 22:13, 7F
→
09/08 22:14, , 8F
09/08 22:14, 8F
推
09/08 22:16, , 9F
09/08 22:16, 9F
推
09/08 22:19, , 10F
09/08 22:19, 10F
推
09/08 22:36, , 11F
09/08 22:36, 11F
推
09/08 22:47, , 12F
09/08 22:47, 12F
→
09/08 22:47, , 13F
09/08 22:47, 13F
→
09/08 23:21, , 14F
09/08 23:21, 14F
→
09/08 23:22, , 15F
09/08 23:22, 15F
→
09/08 23:23, , 16F
09/08 23:23, 16F
推
09/09 18:21, , 17F
09/09 18:21, 17F
推
09/09 18:22, , 18F
09/09 18:22, 18F
→
09/09 18:22, , 19F
09/09 18:22, 19F