[算表] Union和copy圖表的問題
軟體:
Excel
版本:
2007
我的Excel問題在此連結
http://ppt.cc/Wvtq
灰色的部份是我要copy到sheets(2)的
Dim rng As Range
Set rng = Union(Range("D1:D12"), Range("E1:L17"))
rng.Copy Sheets(2).Range("A1")
我有幾個問題
1.為什麼這樣寫不work？
2.如果我退而求其次，不用union而用range("D1:D12").copy和Range("E1:L17").copy
是ok的！圖片也會一併copy過去
但是在sheets2新的圖表的資料點仍是瞄到sheets(1)的
怎麼樣可以讓它瞄到sheets2的資料呢？
或是copy過去時將圖表變成圖片？
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 111.251.196.80
→
11/13 21:08, , 1F
11/13 21:08, 1F
→
11/13 21:13, , 2F
11/13 21:13, 2F
→
11/13 21:15, , 3F
11/13 21:15, 3F
→
11/13 21:17, , 4F
11/13 21:17, 4F
→
11/13 21:20, , 5F
11/13 21:20, 5F
※ 編輯: cataphract 來自: 111.251.196.80 (11/13 21:20)
→
11/13 21:22, , 6F
11/13 21:22, 6F
→
11/13 21:22, , 7F
11/13 21:22, 7F
→
11/13 21:22, , 8F
11/13 21:22, 8F
→
11/13 22:33, , 9F
11/13 22:33, 9F
→
11/13 22:37, , 10F
11/13 22:37, 10F
→
11/13 22:38, , 11F
11/13 22:38, 11F
→
11/13 22:41, , 12F
11/13 22:41, 12F
→
11/13 22:42, , 13F
11/13 22:42, 13F
→
11/13 22:42, , 14F
11/13 22:42, 14F
※ 編輯: cataphract 來自: 111.251.196.80 (11/13 23:15)
→
11/14 02:44, , 15F
11/14 02:44, 15F
→
11/14 22:34, , 16F
11/14 22:34, 16F
→
11/14 22:35, , 17F
11/14 22:35, 17F
→
11/15 00:55, , 18F
11/15 00:55, 18F
→
11/15 00:55, , 19F
11/15 00:55, 19F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
