Forum Discussion
Error looking time "14:00" in VBA with . FIND function
Good morning I have a strange problem. I found this problem in Excel 365 Pro e Excel 2016 Pro. I have a column that contains hour value from 8:00 to 18:00 step by half hour. The cell is formatted w...
The problem was I didn't find the entire string with LookAt:=xlWhole. The system changed the "14:00" in "2.00 pm" and the first string it found was a partial string "2:00" in "12:00".