Excel skip to the next row

[bbimuyi]

I was able to solve using a Boolean

. So if I encounter a row than I set the value to true. The for loop proceeds and if the next row has a value I grab it. If it is null than I skip to the next occurrence of the original condition.

Thanks for your insight:)