質問編集履歴
3
コード編集
test
CHANGED
File without changes
|
test
CHANGED
@@ -86,7 +86,7 @@
|
|
86
86
|
|
87
87
|
m1 = awb1.Cells(Rows.Count, 3).End(xlUp).Row
|
88
88
|
|
89
|
-
n1 = awb
|
89
|
+
n1 = awb2.Cells(Rows.Count, 3).End(xlUp).Row
|
90
90
|
|
91
91
|
|
92
92
|
|
2
誤字編集
test
CHANGED
File without changes
|
test
CHANGED
@@ -130,7 +130,7 @@
|
|
130
130
|
|
131
131
|
実行するとこうなります。
|
132
132
|
|
133
|
-
これを1行追加するのではなく、必ず5行
|
133
|
+
これを1行追加するのではなく、それぞれの項目が必ず5行になるようにしたいです。
|
134
134
|
|
135
135
|
|
136
136
|
|
1
コードの追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -38,9 +38,89 @@
|
|
38
38
|
|
39
39
|
|
40
40
|
|
41
|
-
```
|
41
|
+
```VBA
|
42
42
|
|
43
|
+
Sub CommandButton1_Click()
|
44
|
+
|
45
|
+
Dim wb1 As Workbook
|
46
|
+
|
47
|
+
Dim awb1 As Worksheet
|
48
|
+
|
49
|
+
Dim wb2 As Workbook
|
50
|
+
|
51
|
+
Dim awb2 As Worksheet
|
52
|
+
|
53
|
+
Dim m As Long
|
54
|
+
|
55
|
+
Dim n As Long
|
56
|
+
|
57
|
+
|
58
|
+
|
59
|
+
Set wb1 = ActiveWorkbook
|
60
|
+
|
61
|
+
Set awb1 = wb1.Worksheets(1)
|
62
|
+
|
63
|
+
|
64
|
+
|
65
|
+
Workbooks.Add
|
66
|
+
|
67
|
+
|
68
|
+
|
69
|
+
Set wb2 = ActiveWorkbook
|
70
|
+
|
71
|
+
Set awb2 = wb2.Worksheets(1)
|
72
|
+
|
73
|
+
|
74
|
+
|
75
|
+
awb1.Columns(2).Copy
|
76
|
+
|
77
|
+
awb2.Columns(2).PasteSpecial
|
78
|
+
|
79
|
+
|
80
|
+
|
81
|
+
awb1.Columns(3).Copy
|
82
|
+
|
83
|
+
awb2.Columns(3).PasteSpecial
|
84
|
+
|
85
|
+
|
86
|
+
|
87
|
+
m1 = awb1.Cells(Rows.Count, 3).End(xlUp).Row
|
88
|
+
|
89
|
+
n1 = awb1.Cells(Rows.Count, 3).End(xlUp).Row
|
90
|
+
|
91
|
+
|
92
|
+
|
93
|
+
For m = 2 To n1
|
94
|
+
|
95
|
+
m2 = awb2.Cells(n1, 3)
|
96
|
+
|
97
|
+
m3 = awb2.Cells(n1 - 1, 3)
|
98
|
+
|
99
|
+
|
100
|
+
|
101
|
+
If Not m2 = m3 Then
|
102
|
+
|
103
|
+
awb2.Rows(n1).Insert
|
104
|
+
|
43
|
-
|
105
|
+
End If
|
106
|
+
|
107
|
+
|
108
|
+
|
109
|
+
n1 = n1 - 1
|
110
|
+
|
111
|
+
If n1 = 2 Then
|
112
|
+
|
113
|
+
Exit For
|
114
|
+
|
115
|
+
End If
|
116
|
+
|
117
|
+
|
118
|
+
|
119
|
+
Next m
|
120
|
+
|
121
|
+
|
122
|
+
|
123
|
+
End Sub
|
44
124
|
|
45
125
|
```
|
46
126
|
|
@@ -48,9 +128,13 @@
|
|
48
128
|
|
49
129
|
### 試したこと
|
50
130
|
|
131
|
+
実行するとこうなります。
|
132
|
+
|
133
|
+
これを1行追加するのではなく、必ず5行分追加されるようにしたいです。
|
51
134
|
|
52
135
|
|
136
|
+
|
53
|
-
|
137
|
+
![イメージ説明](77d64388a250d1e6acd2986e7c6de07e.png)
|
54
138
|
|
55
139
|
|
56
140
|
|