• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SPP ClearContents on table column2 Date < Today

S P P

Member
Good morning!

ClearContents on table column2 Date < Today
 

Attachments

  • SPP ClearContents on table column2 Date smaller Today.xlsm
    21.5 KB · Views: 3
Code:
  For Each cll In Range("Tabela1[Date]").Cells
      If cll.Value < Date Then cll.ClearContents
  Next cll
 
Back
Top