|
楼主 |
发表于 2010-8-27 20:17
|
显示全部楼层
Zamyi老师走了!
顶起来,哪位老师能够帮助解决一下?试了遍历,达到预期的目的,感谢Zamyi老师指点!
代码如下:
Bay = ADList.Count
For y = 0 To Bay - 1
WKAD = Split(ADList.Keys(y), "--")(1)
WK = Split(ADList.Keys(y), "--")(0)
Temp = Range(Replace(WKAD, 5, 9))
zzz = UBound(WorksheetFunction.Transpose(Temp))
ReDim TempOEE(1 To ItemsNu.Count, 1 To zzz)
For z = 0 To ItemsNu.Count - 1
jjj = Replace(WKAD, "5", ItemsNu.Keys(z))
Tempo = Range(jjj)
zzz = UBound(WorksheetFunction.Transpose(Tempo))
For zz = 1 To zzz
TempOEE(z + 1, zz) = Tempo(1, zz)
Next
Next
[ 本帖最后由 praijna 于 2010-8-27 22:19 编辑 ] |
|