Loop instructions for number of active rows

Hi

1) As you haven't nominated a with statement, then you don't need the .cells or .range approach. Remove the . from the reference.

2) To cycle through the range of row numbers try

Please Login or Register  to view this content.

3) I'm not really sure what you are trying to do with the rest of the code. If the above don't get you going, then perhaps try to explain what you want it to do.....

rylo

That works for part 1.

Still having a problem with part 2 of question.

The way the code should look through the first cycle is as such:

Please Login or Register  to view this content.

The way the code should look through the second cycle is as such:

Please Login or Register  to view this content.

So as the code loops it first looks at the data that is stored in B2 & C2 and returns a value in D2. Then it repeats for row 3, 4, 5, 6, 7, ...... and so on until it reaches the last row.

Hope this makes more since. I have attached a copy of the file with all the code and how the page is layed out if needed. Thanks for the help.

Hi

Try using this command line

Please Login or Register  to view this content.

It failed for me as I don't have pWinHttpRequest

rylo

That's the trick. Works like a charm now. I also had to update code two lines below. Final working code is as follows:

Please Login or Register  to view this content.

Thanks for all the help.