回答編集履歴
2
修正
test
CHANGED
@@ -30,7 +30,7 @@
|
|
30
30
|
|
31
31
|
Set FromRng = Wh.Range(Wh.Range("A8"), Wh.Cells(Wh.Rows.Count, 33).End(xlUp))
|
32
32
|
|
33
|
-
Rows.Countは一律
|
33
|
+
Rows.Countは一律なのでWhなくてもよいかな
|
34
34
|
|
35
35
|
|
36
36
|
|
1
修正
test
CHANGED
@@ -30,7 +30,9 @@
|
|
30
30
|
|
31
31
|
Set FromRng = Wh.Range(Wh.Range("A8"), Wh.Cells(Wh.Rows.Count, 33).End(xlUp))
|
32
32
|
|
33
|
-
Rows.Countは一律
|
33
|
+
Rows.Countは一律?フイルターかけた後は
|
34
|
+
|
35
|
+
|
34
36
|
|
35
37
|
|
36
38
|
|