I am getting the error "Conversion from string "" to type 'Date' is not valid." from the following line of code:
If oSheet.Cells(i, 6).value = "" Then Exit For
What I am doing is adding values from excel into a CheckedListbox. The values are dates, and the line above is just to check to make sure that the excel cell is not blank. It worked fine for stings and values, but dates it is getting hung up on. Any ideas how to fix this?