Add a line to display the variable values:
Before the line DV = ...
It's probably in one of those![]()
Debug.Print DayNum, Mnth, Yr
Another thing, no date separtor? Datevalue expects a string with the format
![]()
DV = DateValue( DayNum & "/" & Mnth & "/" Yr)
Bookmarks