you are viewing a single comment's thread
view the rest of the comments
[–] 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.

  • source
  • parent