Infinite Loop Error

[ShennyP]

Okay so basically I want to print each individual iteration of this loop (I will be adding in way more for loops when I get this working) to print the value of a certain cell as well as the values of my variables which are changing for each iteration. I therefore need to set up a counter which I can use as the row for each iteration and I am having an issue with it as it is going infinite. I don't have any experience with VBA but this would work in other languages I briefly used at uni unless I am mistaken. So basically the output of this is value a 1, value b is 1 and the value being printed into to column 52 is in tern the same and this is printing infinitely downwards from row 75 (which is where count starts). I am hoping my mistake is obvious, thanks for helping!

Please Login or Register  to view this content.

[cytop]

You need to change the declaration for a & b.

More details when this thread complies with the forum rules - in particular #3: Code tags

[ShennyP]

You need to change the declaration for a & b.

More details when this thread complies with the forum rules - in particular #3: Code tags

Sorry fixed it up.

I thought it was an issue with the count, but like I said I have little experience in vba

[mikerickson]

You need to declare A and B as Double, because the .5 increment doesn't work with data type Long.

Your use of the count variable looks like the way to go. Although if there are potentially lots of rows involved, you would want to type that as Long rather than Integer.

[cytop]

Deleted. Answered while composing message