VBA Code to hide rows with previous dates in excel | Macro to hide rows based on dates in excel
Before applying Macro, follow the steps to apply Macro on Excel.
Open Excel Sheet
Press Alt + F11 Key
Go to the Insert Menu and Click on new Module
in New Module copy and paste the above VBA code and save.
Now Press Alt + F8 and new windows will open which is shown in below figure,
in that windows you will ask to enter a key to create shortcut for Paste Special
Enter a letter in the box.
Press Alt + F11 Key
Go to the Insert Menu and Click on new Module
in New Module copy and paste the above VBA code and save.
Now Press Alt + F8 and new windows will open which is shown in below figure,
in that windows you will ask to enter a key to create shortcut for Paste Special
Enter a letter in the box.
Sub Hide_Dates()
Dim MyRange As Range, c As Range
Set MyRange = Range("H2:H4436")
MyRange.EntireRow.Hidden = False
For Each c In MyRange
If IsDate(c.Value) And c.Value < Date Then
c.EntireRow.Hidden = True
End If
Next
End Sub
