I am automating a process that look at dates in a pivot table and make visible only the dates in the range. the code look for the last day that the program was run and make the range between that date and yesterday. The problem I am having is that if one of the dates in the range is missing...