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