I have a VBA COUNTIF statement that will not evaluate a value within a cell unless I go into the call and re-type the cell. The cell value is text. As an example in the cell is 10.10.2018. If I go into the cell and re-type in the value (note I was sent the spreadsheet, I did not type the original value).
When I set a variable to the cell it correctly displays "10.10.2018" (before any re-type. Thus, why am I forced to re-type in the value in order for the CountIf to recognize the value ?
Count = Application.CountIf(Cells(5, i), "10.10.2018")