S S P P Member Apr 28, 2023 #1 Good morning! ClearContents on table column2 Date < Today Attachments SPP ClearContents on table column2 Date smaller Today.xlsm 21.5 KB · Views: 3
p45cal Well-Known Member Apr 28, 2023 #2 Code: For Each cll In Range("Tabela1[Date]").Cells If cll.Value < Date Then cll.ClearContents Next cll
Code: For Each cll In Range("Tabela1[Date]").Cells If cll.Value < Date Then cll.ClearContents Next cll