返回列表 上一主題 發帖

[發問] 篩選相關的數據

Sub TEST1()
Dim xR As Range, xH As Range, xU As Range, j&
Sheets("工作表1").UsedRange.Clear
Set xH = [工作表1!A2]
[嘉義!A1].Copy xH(0)
For Each xR In Range([嘉義!A2], [嘉義!A65536].End(xlUp))
  If xR.Row = 1 Then Exit Sub
  If xR = "" Then GoTo 101
  Set xU = xR.Resize(6, 2)
  For j = [C1].Column To [Z1].Column
    If xR(1, j) >= 36 Then Set xU = Union(xU, xR(1, j).Resize(6))
  Next j
  xU.Copy xH
  Set xH = xH(8)
101: Next
End Sub 

TOP

        靜思自在 : 君子如水,隨方就圓,無處不自在。
返回列表 上一主題