Is it possible to compare an item in a collection to the very next item using a FOR EACH loop?
I’d like to do something like this but I’m not sure what the syntax would be:
For Each Item in Collection
If item = item+1 Then…
Here, “item” = the initial item and “Item+1” is the value of the item next iteration of the loop.