Excel VBA variant 数据传输问题

来源:百度知道 编辑:UC知道 时间:2024/06/08 20:36:43
程序如下:
Public i As Integer
Public j As Integer
Sub TestSignal()
Dim iRowOfNum As Integer
iRowOfNum = 9886
Dim iColuOfNum As Integer
iColuOfNum = 3
Dim daData() As Variant
ReDim daData(1 To iRowOfNum, 1 To iColuOfNum)
For i = 1 To iRowOfNum
daData(i, 1) = Worksheets("TD Sequential").Cells(i + 12, 1)
daData(i, 2) = Worksheets("TD Sequential").Cells(i + 12, 5)
daData(i, 3) = Worksheets("TD Sequential").Cells(i + 12, 11)
Next i
Dim sAsk As String
Dim sBid As String
sAsk = "Ask"
sBid = "Bid"
Dim daResult() As Variant
ReDim daResult(1 To iRowOfNum, 1 To iColuOfNum)
Dim iRowOfResult As Integer
'Call TestResult(iRowOfNum, iColuOfNum, daData, sAsk, sBid, daResult, iRowOfResult)
For i = 1 To iRowOfResult
For j = 1 To iColuOfNum

试了一下,可以正确赋值。这句貌似没问题。
你调试的时候这句执行了没有?如果只是黄色高亮而没有再按一下F8执行这句,那么daData(i, 1)没有得到赋值,当然就是空了。
你的TD是Test Director吗?