Forum Discussion

salley's avatar
salley
Frequent Contributor
7 years ago

issue with DDT driver method

Hi, i'm trying to iterate through data, and when there's no more data it's throwing a VBScript runtime error saying Invalid use of Null:  ** any help would be highly appreciated Below is my code ...
  • tristaanogre's avatar
    tristaanogre
    7 years ago

    Right... as mentioned, it's reaching row 11 improperly, probably because that is an "Active" row in your spreadsheet.

     

    Go to your spreadsheet, highlight the ENTIRE row that is the first "blank" row at the end of your data, right click, and select "Delete Row".  Save the spreadsheet and try again.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

Right... as mentioned, it's reaching row 11 improperly, probably because that is an "Active" row in your spreadsheet.

 

Go to your spreadsheet, highlight the ENTIRE row that is the first "blank" row at the end of your data, right click, and select "Delete Row".  Save the spreadsheet and try again.

salley's avatar
salley
Frequent Contributor
7 years ago

Thanks, that didn't seem like to work, so what i did i copied only first two columns into a different worksheet and it's working. so the question is why didn't it work on that sheet when i had no data on row 11 even after completely deleted the row. still it was throwing me error. 

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    7 years ago

    This is one of the reasons why I don't like Excel... there's no clear "end of file" in the actual spreadsheet.  If I'm going to use a file for data processing, I prefer CSV...

     

    ... but I'm convinced that somewhere in that initial data, you had some kinda of erroneous blank row that it's trying to process.  Glad that you corrected it with a new file.

    • salley's avatar
      salley
      Frequent Contributor
      7 years ago

      Thank you so much for your help. I really appreciate your help. 

      TC ! Cheers