16,554
社区成员
发帖
与我相关
我的任务
分享
Dim aryCI(rowcount - 2, 0) As Object, aryCInum() As Integer, aryCIindex(0) As String, s As String
aryCI = .Range(.Cells(2, locBc(2)), .Cells(rowcount, locBc(2))).Value
ReDim aryCIindex(0)
aryCIindex(0) = aryCI(0, 0)
Dim Fn As String
Fn = "票.xls"
Dim Ex As New Excel.Application
Dim ExBook As Excel.Workbook
ExBook = Ex.Workbooks.Open(Fn)
Ex.DisplayAlerts = False
Dim aryCI(5, 0) As Object, aryCIindex(0) As String
With Ex
aryCI = .Range(.Cells(2, 1), .Cells(8, 1)).Value '此处设置断点
'可以看到aryCI的范围从(1,1)开始,无论Range的范围是多少都是一样
ReDim aryCIindex(0)
aryCIindex(0) = aryCI(0, 0)
End With
Dim aryCIindex() As Object
ReDim aryCIindex(0)
aryCIindex(0) = 1
Dim aryCI(,) As Object, aryCIindex() As Object, aryCInum() As Integer
aryCI = .Range(.Cells(2, locBc(2)), .Cells(rowcount, locBc(2))).Value
ReDim aryCIindex(0)
aryCIindex(0) = aryCI(0, 0)