Thanks!
2 questions:
1)What is the purpose of the line
2)is it possible to avoid of hardcoding the date items in the code (Macro1())? WE already have the dates in data validation of the cell.![]()
If Intersect(Range("A1"), Target) Is Nothing Then Exit Sub
Bookmarks