我正试图将一张单张上的一组滴答分解成多张。基本上,我试图使用"i“变量作为工作表标识符和每个工作表上的滴答数乘数来循环多个工作表。
有人能发现我在这里犯的错误吗?或者你推荐的其他方法来攻击这个?
"BreakdownCount“=用户输入分组size...in --本例为200作为测试。
谢谢!
For i = 1 To BreakdownCount
UpperRange = 8 + (i - 1) * 200
LowerRange = 8 + i * 200
MsgBox UpperRange
MsgBox LowerRange
Worksheets("Data " & i).Range(Cells(8, 2), Cells(207, 2)).Value = Worksheets("Scanner - ALL").Range(Cells(UpperRange, 2), Cells(LowerRange, 2)).Value
Next发布于 2017-08-23 17:09:08
您需要用父表对所有范围对象进行限定。它包括范围()中的Cells():
For i = 1 To BreakdownCount
UpperRange = 8 + (i - 1) * 200
LowerRange = 8 + i * 200
MsgBox UpperRange
MsgBox LowerRange
Worksheets("Data " & i).Range(Worksheets("Data " & i).Cells(8, 2), Worksheets("Data " & i).Cells(207, 2)).Value = Worksheets("Scanner - ALL").Range(Worksheets("Scanner - ALL").Cells(UpperRange, 2), Worksheets("Scanner - ALL").Cells(LowerRange, 2)).Value
Next一只小短手:
Dim wsOut as Worksheet
With Worksheets("Scanner - ALL")
For i = 1 To BreakdownCount
Set wsOut = Worksheets("Data " & i)
UpperRange = 8 + (i - 1) * 200
LowerRange = 8 + i * 200
MsgBox UpperRange
MsgBox LowerRange
wsOut.Range(wsOut.Cells(8, 2), wsOut.Cells(207, 2)).Value = .Range(.Cells(UpperRange, 2), .Cells(LowerRange, 2)).Value
Next
End Withhttps://stackoverflow.com/questions/45845594
复制相似问题