For iValue = 2 to 10
In this example, we want to take 1+ the value of whatever is in column A for the first 10 rows and put the new value in column B.
This could be done with a simple formula in column B, but it wouldn’t help show how to work with data.
This will use a for loop. For loops run the same script from one number to the next specified. In this case from row 2 to row 10.