|
楼主 |
发表于 2019-11-28 09:41
|
显示全部楼层
本帖最后由 lkk0063 于 2019-11-28 09:42 编辑
版主你好,
测试后,可以了, 没注意原来 "K" 栏位可以控制想要显示数值
我有两句程式码弄不清(红字部分),可否注解
(1)
For i = 3 To UBound(A)
For j = 1 To 5
k = k + 1
B(1, k) = IIf(j > A(i, 11), "", A(i, j + 5))
*********************************************************
原程式码 :
Sub step1()
Dim i, j, k
ThisWorkbook.Activate
A = Range("a1").CurrentRegion
B(1, 1) = [G1]
B(1, 2) = [C1]
B(1, 3) = [E1]
k = 3
For i = 3 To UBound(A)
For j = 1 To 5
k = k + 1
B(1, k) = IIf(j > A(i, 11), "", A(i, j + 5))
Next j
Next i
End Sub
*********************************************************
(2)
Cells(6, 1).Resize(1, UBound(B, 2)) = B
*********************************************************
原程式码 :
'To Test-FQC
Sub step2()
Dim p, f
p = ThisWorkbook.Path & "\"
f = "Test-FQC.xls"
Call step3(f)
With Workbooks.Open(p & f)
Cells(6, 1).Resize(1, UBound(B, 2)) = B
.Close True
End With
End Sub
*********************************************************
|
|