Is there a way I can either see the row # I am at or count the number of iterations I am on in StudioX? I would just like to use an assign variable and increase it by 1 at each iteration, but I don’t think you can use variables in StudioX.
Without a variable, my thought was to get current row’s row number, but I can’t figure out how to do this.
So excluding the header, my file has 16 rows…and the output is capturing the count perfectly.
Note: You don’t have to type Saved.Values(Of Integer)("Counter") everytime, once you saved the value as integer first time, then you can easily use the + button and add it.
Hello, do you know if this option is available in StudioX? I tried this for a few different For Each Excel loops, but I don’t see the “Current Index” option.