▲ 762 ▼ looks good to me (lemm.ee) submitted 2 years ago by Irelephant@lemm.ee to c/programmer_humor@programming.dev 47 comments fedilink hide all child comments
[–] Willem@kutsuya.dev 19 points 2 years ago (2 children) On Error Resume Next Visual Basic is a beautiful language permalink fedilink source parent hideshow 4 child comments replies: [–] Knock_Knock_Lemmy_In@lemmy.world 5 points 2 years ago On error goto 0 Was always syntacticly confusing for me. permalink fedilink source parent [–] runner_g@lemmy.blahaj.zone 1 point 2 years 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. permalink fedilink source parent
[–] Knock_Knock_Lemmy_In@lemmy.world 5 points 2 years ago On error goto 0 Was always syntacticly confusing for me. permalink fedilink source parent
[–] runner_g@lemmy.blahaj.zone 1 point 2 years 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. permalink fedilink source parent