請測試看看,謝謝
Sub test()
Dim Arr, j&, xU As Range
Arr = [a1].CurrentRegion
For j = 3 To UBound(Arr, 2)
If Date - 7 > Arr(1, j) Then
If xU Is Nothing Then Set xU = Columns(j) Else Set xU = Union(Columns(j), xU)
End If
Next
If Not xU Is Nothing Then xU.EntireColumn.Hidden = True
End Sub
請測試看看,謝謝
Sub test()
Dim Arr, j&, xU As Range
Arr = [a1].CurrentRegion
For j = 3 To UBound(Arr, 2)
If Date - 7 > Arr(1, j) Then
If xU Is Nothing Then Set xU = Columns(j) Else Set xU = Union(Columns(j), xU)
End If
Next
If Not xU Is Nothing Then xU.EntireColumn.Hidden = True
End Sub