数据表在sheet1,结果填入sheet2,在sheet1插入控件,指定如下程序运行即可 Sub rr()Dim i%, k%, j, arr()'Sheet2.Range("b2:z100").ClearContents不知道你的填充范围,不过这句很有必要,最后确定范围后加上For i = 2 To Range("a65536").End(xlUp).Row
For k = 2 To Cells(i, 200).End(xlToLeft).Column
If Cells(i, k)"" Then
j = j + 1
s = s & "," ...
|