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

2025-03-04 12:01:39
推荐回答(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