I have a function that imports an Excel sheet into a SQL database. This function works except ONE line.
If sheetContent.Range("A" & exRow).Value2.ToString.Length < 1 Then Exit For End If
The rest of this function works great, and it uses lines of code that are VERY similar to that one.
The error I'm getting is:
System.NullReferenceException: Object reference is not set to an instance of an object.
Anyone have any ideas? All help is MUCH appreciated!