<div> Sheets("논문").Select</div> <div> Range("I347").Select</div> <div> Range("I347").GoalSeek Goal:=0, ChangingCell:=Range("G347")</div> <div> Range("I348").Select</div> <div> Range("I348").GoalSeek Goal:=0, ChangingCell:=Range("G348")</div> <div> Range("I349").Select</div> <div> Range("I349").GoalSeek Goal:=0, ChangingCell:=Range("G349")</div> <div> Range("I350").Select</div> <div> Range("I350").GoalSeek Goal:=0, ChangingCell:=Range("G350")</div> <div> Range("I351").Select</div> <div> Range("I351").GoalSeek Goal:=0, ChangingCell:=Range("G351")</div> <div> Range("I352").Select</div> <div> Range("I352").GoalSeek Goal:=0, ChangingCell:=Range("G352")</div> <div> Range("I353").Select</div> <div> Range("I353").GoalSeek Goal:=0, ChangingCell:=Range("G353")</div> <div> Range("I354").Select</div> <div> Range("I354").GoalSeek Goal:=0, ChangingCell:=Range("G354")</div> <div> Range("I355").Select</div> <div> Range("I355").GoalSeek Goal:=0, ChangingCell:=Range("G355")</div> <div> Range("I356").Select</div> <div> Range("I356").GoalSeek Goal:=0, ChangingCell:=Range("G356")</div> <div> ActiveWindow.SmallScroll Down:=93</div> <div> Sheets("입력값").Select</div> <div> Range("G66").Select</div> <div><br></div> <div><br></div> <div> Sheets("논문").Select</div> <div> Range("B432").Select</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> Range("J434").Select</div> <div> Range("J434").GoalSeek Goal:=0, ChangingCell:=Range("H434")</div> <div> Range("J435").Select</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> Range("K434").Select</div> <div> Range("K434").GoalSeek Goal:=0, ChangingCell:=Range("H434")</div> <div> Range("K435").Select</div> <div> Range("K435").GoalSeek Goal:=0, ChangingCell:=Range("H435")</div> <div> Range("K436").Select</div> <div> Range("K436").GoalSeek Goal:=0, ChangingCell:=Range("H436")</div> <div> Range("K437").Select</div> <div> Range("K437").GoalSeek Goal:=0, ChangingCell:=Range("H437")</div> <div> Range("K438").Select</div> <div> Range("K438").GoalSeek Goal:=0, ChangingCell:=Range("H438")</div> <div> Range("K439").Select</div> <div> Range("K439").GoalSeek Goal:=0, ChangingCell:=Range("H439")</div> <div> Range("K440").Select</div> <div> Range("K440").GoalSeek Goal:=0, ChangingCell:=Range("H440")</div> <div> Range("K441").Select</div> <div> Range("K441").GoalSeek Goal:=0, ChangingCell:=Range("H441")</div> <div> Range("K442").Select</div> <div> Range("K442").GoalSeek Goal:=0, ChangingCell:=Range("H442")</div> <div> Range("K442").GoalSeek Goal:=0, ChangingCell:=Range("H442")</div> <div> Range("K443").Select</div> <div> Range("K443").GoalSeek Goal:=0, ChangingCell:=Range("H443")</div> <div> Sheets("입력값").Select</div> <div> Range("G69").Select</div> <div><br></div> <div> Sheets("논문").Select</div> <div> Range("A489").Select</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.SmallScroll Down:=3</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("V490").Select</div> <div> Range("V490").GoalSeek Goal:=0, ChangingCell:=Range("F490")</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("V491").Select</div> <div> Range("V491").GoalSeek Goal:=0, ChangingCell:=Range("F491")</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> ActiveWindow.ScrollColumn = 16</div> <div> Range("V492").Select</div> <div> Range("V492").GoalSeek Goal:=0, ChangingCell:=Range("F492")</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("V493").Select</div> <div> Range("V493").GoalSeek Goal:=0, ChangingCell:=Range("F493")</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("V494").Select</div> <div> Range("V494").GoalSeek Goal:=0, ChangingCell:=Range("F494")</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> Range("V495").Select</div> <div> Range("V495").GoalSeek Goal:=0, ChangingCell:=Range("F495")</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> Range("V496").Select</div> <div> Range("V496").GoalSeek Goal:=0, ChangingCell:=Range("F496")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> Range("V497").Select</div> <div> Range("V497").GoalSeek Goal:=0, ChangingCell:=Range("F497")</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> ActiveWindow.ScrollColumn = 16</div> <div> ActiveWindow.ScrollColumn = 17</div> <div> Range("V498").Select</div> <div> Range("V498").GoalSeek Goal:=0, ChangingCell:=Range("F498")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> Range("V499").Select</div> <div> Range("V499").GoalSeek Goal:=0, ChangingCell:=Range("F499")</div> <div> Sheets("입력값").Select</div> <div> Range("G73").Select</div> <div><br></div> <div> Sheets("논문").Select</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 1</div> <div> Range("B584").Select</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("W570").Select</div> <div> Range("W570").GoalSeek Goal:=0, ChangingCell:=Range("G570")</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> Range("W571").Select</div> <div> Range("W571").GoalSeek Goal:=0, ChangingCell:=Range("G571")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> Range("W572").Select</div> <div> Range("W572").GoalSeek Goal:=0, ChangingCell:=Range("G572")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("W573").Select</div> <div> Range("W573").GoalSeek Goal:=0, ChangingCell:=Range("G573")</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> Range("W574").Select</div> <div> Range("W574").GoalSeek Goal:=0, ChangingCell:=Range("G574")</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> ActiveWindow.ScrollColumn = 15</div> <div> ActiveWindow.ScrollColumn = 16</div> <div> Range("W575").Select</div> <div> Range("W575").GoalSeek Goal:=0, ChangingCell:=Range("G575")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> ActiveWindow.ScrollColumn = 14</div> <div> Range("W576").Select</div> <div> Range("W576").GoalSeek Goal:=0, ChangingCell:=Range("G576")</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> ActiveWindow.ScrollColumn = 13</div> <div> Range("W577").Select</div> <div> Range("W577").GoalSeek Goal:=0, ChangingCell:=Range("G577")</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> ActiveWindow.ScrollColumn = 12</div> <div> Range("W578").Select</div> <div> Range("W578").GoalSeek Goal:=0, ChangingCell:=Range("G578")</div> <div> ActiveWindow.ScrollColumn = 2</div> <div> ActiveWindow.ScrollColumn = 3</div> <div> ActiveWindow.ScrollColumn = 4</div> <div> ActiveWindow.ScrollColumn = 5</div> <div> ActiveWindow.ScrollColumn = 6</div> <div> ActiveWindow.ScrollColumn = 7</div> <div> ActiveWindow.ScrollColumn = 8</div> <div> ActiveWindow.ScrollColumn = 9</div> <div> ActiveWindow.ScrollColumn = 10</div> <div> ActiveWindow.ScrollColumn = 11</div> <div> Range("W579").Select</div> <div> Range("W579").GoalSeek Goal:=0, ChangingCell:=Range("G579")</div> <div> Sheets("입력값").Select</div> <div> Range("G76").Select</div> <div> Sheets("논문").Select</div> <div> Range("D632").Select</div> <div> ActiveSheet.ChartObjects("Chart 355").Activate</div> <div> ActiveChart.ChartArea.Select</div> <div> ActiveWindow.Visible = False</div> <div> Windows("리얼 논문형식.xls").Activate</div> <div> ActiveSheet.Shapes.Range(Array("Chart 355", "Chart 360")).Select</div> <div> ActiveWindow.WindowState = xlNormal</div> <div> ActiveWindow.WindowState = xlMaximized</div> <div> ActiveWindow.WindowState = xlNormal</div> <div> ActiveWindow.WindowState = xlMaximized</div> <div> Selection.Copy</div> <div> Sheets("입력값").Select</div> <div> Range("B80").Select</div> <div> ActiveSheet.Paste</div> <div> Range("F76").Select</div> <div><br></div> <div>명령어가 이렇게 매크로를 만들고 있습니다. 근데 이 명령어 들이 전부 다른 버튼을 누르면 작동이 되는 매크로 들을 복사 붙여 넣기를 한것인데요</div> <div>제가하고 싶은 작업은 또다른 버튼 하나로 다른 버튼들 작업을 한번에 처리 하고 싶은겁니다.</div> <div>근데 자꾸 에러가 뜨는데 뭐가 문제인줄 모르겠네요 혹시 알려주실분 있으신가요?? 어떻게든 해결만 하면 되는 문제라 본삭금 걸었어요 도와주세요</div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.