1) For .... Next
Other statements you may need:
<variable name> = DataTable(<Column Name>, dtLocalSheet) ' or dtGlobalSheet depending on your design
Initialize a variable. This will be your counter. Say i =1, corresponding to 1st row of DataTable.
Increment your counter using For..Next loop for number of times you want to run the loop.
Within the For...Loop set CurrentRow = counter
This may seem like a complicated worded solution but I'd rather that you look up these statements on your own in the manual so you dont forget them again. If you dont understand something let us know, one of us may post a sample code snippet.