这很难描述。
我有一些专栏,比如说三个:
10 20 20
20 22 24
24 24 26
我喜欢得到的是:
10 XX XX
20 20 20
XX 22 XX
24 24 24
XX XX 26
其中 XX 是空单元格。
有办法得到这个吗?
再见,
托马斯
使用 ADO 可以做很多事情。
Dim cn As Object
Dim rs As Object
Dim strFile As String
Dim strCon As String
Dim strSQL As String
Dim s As String
Dim i As Integer, j As Integer
''This is not the best way to refer to the workbook
''you want, but it is very convenient for notes
''It is probably best to use the name of the workbook.
strFile = ActiveWorkbook.FullName
''Note that if HDR=No, F1,F2 etc are used for column names,
''if HDR=Yes, the names in the first row of the range
''can be used.
''This is the Jet 4 connection string, you can get more
''here : http://www.connectionstrings.com/excel
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFile _
& ";Extended Properties=""Excel 8.0;HDR=No;IMEX=1"";"
''Late binding, so no reference is needed
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cn.Open strCon
strSQL = "SELECT 1 As Col, F1 As Cont FROM [Sheet1$] " _
& "UNION ALL SELECT 2 As Col, F2 As Cont FROM [Sheet1$] " _
& "UNION ALL SELECT 3 As Col, F3 As Cont FROM [Sheet1$] " _
& "ORDER BY Cont"
rs.Open strSQL, cn, 3, 3
''Pick a suitable empty worksheet for the results
With Worksheets("Sheet2")
''Working with the recordset ...
Do While Not rs.EOF
If rs("Cont") > j Then i = i + 1
j = rs("Cont")
.Cells(i, rs("Col")) = rs("Cont")
rs.MoveNext
Loop
End With
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)