|
求助,求偶数单元格值
试试: - Sub xx()
- Dim i As Long, m As Long, n As Long
- Dim arr() As String
-
- m = [h65536].End(3).Row + 1 '寻找H列最后一个空单元格
- For i = 6 To 230 Step 2 '向上寻找第6,8,10...230个单元格
- If m - i > 0 Then n = n + 1 Else Exit For '判断有数据的单元格是否少于236个
- ReDim Preserve arr(1 To 1, 1 To n) As String '对数组进行无损扩展
- arr(1, n) = Cells(m - i, "H") '对数组进行赋值
- Next
- [i1:DQ1].ClearContents '先将i1到DQ1单元格的数据清空(第230个单元格数据会填在DQ列)
- [i1].Resize(1, n) = arr '将arr数据从I1列开始,依次填入到第一行
-
- End Sub
复制代码
|
|