teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

修正

2016/07/04 03:16

投稿

jawa
jawa

スコア3020

answer CHANGED
@@ -37,10 +37,10 @@
37
37
  'Next i
38
38
 
39
39
  Dim Achart As ChartObject
40
- Set Achart = Sheet1.ChartObjects("Chart 3")
40
+ Set Achart = ActiveSheet.ChartObjects("Chart 1")
41
41
 
42
42
  Dim Bchart As ChartObject
43
- Set Bchart = Sheet3.ChartObjects("Chart 1")
43
+ Set Bchart = ActiveSheet.ChartObjects("Chart 2")
44
44
 
45
45
  Gwidth = Achart.Width 'エラー箇所
46
46
  Gheight = Achart.Height 'エラー箇所