请高手指教。在VB FOR 循环中设置一个变量

2025-02-26 00:21:41
推荐回答(1个)
回答1:

'假设是针对第5行数据
Dim i As Integer
Dim L As Integer
Dim m() As String

'返回第5行数据区的最大列号到L
L = Excel.Application.ActiveWorkbook.Sheets("Sheet1").Cells(5, 1).CurrentRegion.Columns.Count
ReDim m(L)
For i = 1 To L
m(i) = Excel.Application.ActiveWorkbook.Sheets("Sheet1").Cells(5, i).Text
Print m(i)
Next i