• @Willem
      link
      191 month ago

      On Error Resume Next

      Visual Basic is a beautiful language

      • @runner_g@lemmy.blahaj.zone
        link
        fedilink
        English
        11 month ago

        I legitimately use this line in one of my scripts because range.find returns an error of the value is not found. The use case is taking a 2d matrix saved as an array, with data collected from multiple excel tabs and rearranging it for a CSV upload into Salesforce. The initial array contains values that the rest of the data does not have, so when I search for a non existent value, I can skip the error.

        Of course vba COULD just implement try/catch statements and that’d be so much cleaner, but alas.