I have searched and cannot find a scenario specific to mine, so I apologize if there is a solution out there already.
What I am trying to accomplish:
Using a For Each Excel Row, check the value of CurrentRow.ByIndex(0). If that cell value contains any of the strings in a variable array of type string (lets call is arrString), then send a hotkey.
I tried using an else if statement, and then typing " CurrentRow.ByIndex(0).contains(arrString)" but that obviously doesn’t work.
I have seen posts say to use a for loop - for each value in Array, if arrString.contains(value), set Boolean to true -
I am unable to convert that to dealing with an excel cell value, though