[VBA ] 詢問指定跳到某持儲存格數直的列數
大家好!
巨集我是用錄製的~
內容如下
'Range("K2").Select
Selection.Copy
Application.Goto Reference:="R100C7"
End Sub
K2儲存格可以手key數值(ex.200..)
巨集設定我要跳到第K2值的列&第7欄
照原本的巨集,K2=100
即便我我改了K2=200,也只會跳到R100C7
我要怎麼修改這條編碼讓他可以隨K2的值變動?
ex當K2=150→跳到R150C7
當K2=234→跳到R234C7
非常感謝大家幫忙><
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.51.165.114
※ 文章網址: https://www.ptt.cc/bbs/Visual_Basic/M.1478245195.A.554.html
推
11/04 17:30, , 1F
11/04 17:30, 1F
→
11/04 23:01, , 2F
11/04 23:01, 2F
→
11/10 15:02, , 3F
11/10 15:02, 3F
→
11/10 15:02, , 4F
11/10 15:02, 4F
→
11/10 15:02, , 5F
11/10 15:02, 5F
→
11/10 15:02, , 6F
11/10 15:02, 6F
→
11/10 15:02, , 7F
11/10 15:02, 7F
→
11/10 15:02, , 8F
11/10 15:02, 8F
→
11/10 15:03, , 9F
11/10 15:03, 9F
→
11/10 15:03, , 10F
11/10 15:03, 10F
→
11/10 15:21, , 11F
11/10 15:21, 11F
→
11/10 15:21, , 12F
11/10 15:21, 12F
→
11/10 15:21, , 13F
11/10 15:21, 13F
→
11/10 15:21, , 14F
11/10 15:21, 14F
→
11/10 15:21, , 15F
11/10 15:21, 15F
→
11/10 15:21, , 16F
11/10 15:21, 16F
→
11/10 15:21, , 17F
11/10 15:21, 17F
→
11/10 15:22, , 18F
11/10 15:22, 18F
→
11/10 15:23, , 19F
11/10 15:23, 19F
→
11/10 15:23, , 20F
11/10 15:23, 20F
→
11/10 15:23, , 21F
11/10 15:23, 21F
→
11/10 15:23, , 22F
11/10 15:23, 22F
→
11/10 15:24, , 23F
11/10 15:24, 23F
→
11/10 15:25, , 24F
11/10 15:25, 24F
→
11/10 15:30, , 25F
11/10 15:30, 25F
→
11/10 15:31, , 26F
11/10 15:31, 26F
→
11/19 10:51, , 27F
11/19 10:51, 27F
Visual_Basic 近期熱門文章
PTT數位生活區 即時熱門文章