wie kann ich bestimmte Spalten per VBa ausblenden anhand eines Anfangs und Enddatums?
Vorlage anbei.
https://www.herber.de/bbs/user/102990.xlsx
Gruß
' **********************************************************************
' Modul: Tabelle1 Typ: Element der Mappe(Sheet, Workbook, ...)
' **********************************************************************
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range, rngH As Range
If Not Intersect(Target, Range("B5:C5")) Is Nothing Then
For Each rng In Range("F5:R5")
If rng < Range("B5") Or rng > Range("C5") Then
If rngH Is Nothing Then
Set rngH = rng
Else
Set rngH = Union(rngH, rng)
End If
End If
Next
Range("F5:R5").EntireColumn.Hidden = False
If Not rngH Is Nothing Then rngH.EntireColumn.Hidden = True
End If
End Sub
Private Sub Worksheet_Calculate()
Dim rng As Range, rngH As Range
For Each rng In Range("AD14:ACJ14")
If rng < Range("O33") Or rng > Range("P33") Then
If rngH Is Nothing Then
Set rngH = rng
Else
Set rngH = Union(rngH, rng)
End If
End If
Next
Range("AD14:ACJ14").EntireColumn.Hidden = False
If Not rngH Is Nothing Then rngH.EntireColumn.Hidden = True
End Sub