回答編集履歴
2
08だった
test
CHANGED
|
@@ -1,10 +1,10 @@
|
|
|
1
|
-
worksheets(8)がws8のことであれば
|
|
1
|
+
worksheets(8)がws08のことであれば
|
|
2
2
|
|
|
3
3
|
```vba
|
|
4
4
|
|
|
5
5
|
'SourceData:=worksheets(8).range(cells(1,1),cells(i,j))
|
|
6
6
|
|
|
7
|
-
SourceData:=ws8.Name & "!" & ws8.Range(ws8.Cells(1,1),ws8.Cells(i,j)).Address
|
|
7
|
+
SourceData:=ws08.Name & "!" & ws08.Range(ws08.Cells(1,1),ws08.Cells(i,j)).Address
|
|
8
8
|
|
|
9
9
|
```
|
|
10
10
|
|
1
追記
test
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
|
|
5
5
|
'SourceData:=worksheets(8).range(cells(1,1),cells(i,j))
|
|
6
6
|
|
|
7
|
-
SourceData:=ws8.Range(ws8.Cells(1,1),ws8.Cells(i,j))
|
|
7
|
+
SourceData:=ws8.Name & "!" & ws8.Range(ws8.Cells(1,1),ws8.Cells(i,j)).Address
|
|
8
8
|
|
|
9
9
|
```
|
|
10
10
|
|