In Excel, if there are rows with more than 16 characters, I delete them from that sheet and copy them to another.
Everything works fine, but when finished it restarts the validation and then fails because there are no more rows that meet the criteria below:
(dtInput.AsEnumerable (). Where (Function (row) row ("Invoice-Number"). ToString.Length> 16) .CopyToDataTable)
What am I doing wrong?