vendredi 27 mars 2015

Hiding rows in Excel based on date

I am needing to automatically hide rows in excel that have a past date in column H3:H3000. The code below doesn't do anything when I input it: Sub HideRowsDate() Dim cell As Range For Each cell In Range("H3:A350") If cell.Value <= Now Then cell.EntireRow.Hidden = True End If Next End Sub


Aucun commentaire:

Enregistrer un commentaire