One issue that I just realized is that if the worksheet is new (user has not yet input any dates in the target column), it gives a run-time error upon opening the worksheet. When I hit DeBug it highlights the following line:
Code:
If Date >= DateAdd("yyyy", 1, cel) Then
What might we code in to avoid the run-time issue for a blank worksheet?