D_R_1009 https://blog.hatena.ne.jp/D_R_1009/ Continuity is The Father of Success https://blog.dr1009.com/ Develop ※昔書いた記事を某所から移行。 先日マクロで２つのファイルを結合して並べ替える処理を作ったので備忘録的に。 マクロって難しいですね。 Public Const MITSUMORI As String = "見積もり" Public Const SHIRE As String = "仕入れ先" Public Const KATABAN As String = "型番" Public Const KINGAKU As String = "金額" Sub Main() ' シートの用意 Call ClearWorkSheets Call CreateWorkSheets Call CopyToWor… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.dr1009.com%2Fentry%2F2020%2F03%2F31%2F190847" title="２つのシートを並べ替えて結合する処理 - Continuity is The Father of Success" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2020-03-31 19:08:47 rich https://blog.dr1009.com/entry/2020/03/31/190847 1.0 100%