Is there a way to read a range in excel looping through the rows ? I need to read the rows and create a datatable using 100 rows every time, for example, If my input file contains 400 rows, the loop should move like this inside the Range
1 Loop: “A1:A100”
2 Loop: “A101:A200”
3 Loop: “A201:A300”
4 Loop: “A301:A400”
Also, It should use variables, so far I’m using “A”+VarStart + “1:A” + VarEnd for the syntax but I don’t know how to increase the variables to position in the right cell. Any idea would be greatly appreciated.