回答編集履歴
2
修正
test
CHANGED
@@ -50,9 +50,9 @@
|
|
50
50
|
|
51
51
|
|
52
52
|
|
53
|
-
For i = 1 To
|
53
|
+
For i = 1 To UBound(Table1, 1) Step 1 'Sheet1のデータ最終行まで
|
54
54
|
|
55
|
-
For k = 1
|
55
|
+
For k = 1 to UBound(Table2, 1) Step 1 'Sheet1とSheet2のデータがまったく同じかを確認
|
56
56
|
|
57
57
|
If Table2(k, 2) = "" Then
|
58
58
|
|
1
修正
test
CHANGED
@@ -50,9 +50,9 @@
|
|
50
50
|
|
51
51
|
|
52
52
|
|
53
|
-
For i =
|
53
|
+
For i = 1 To Endrow - 1 Step 1 'Sheet1のデータ最終行まで
|
54
54
|
|
55
|
-
For k =
|
55
|
+
For k = 1 To Finalrow -2 Step 1 'Sheet1とSheet2のデータがまったく同じかを確認
|
56
56
|
|
57
57
|
If Table2(k, 2) = "" Then
|
58
58
|
|