For Loop - getting Qualifier error

[Grilleman]

Hello -

I'm trying to learn how to write For loops. The code below keeps returning a "Qualifier" error but I can't figure out why.

Please Login or Register  to view this content.

My workbook is also attached.

Thanks for any insights!

Grilleman

[JieJenn]

Please Login or Register  to view this content.

[Richard Buttrey]

Just a general point

Loops are an important part of any programming language so do continue to play around with them and learn.
However in an Excel application don't get carried away with them. I've lost track of the number of times I've seen looping code when it just isn't necessary. Loops, particularly when processing large ranges, carry a large time overhead since with every iteration of the loop VBE needs to jump back into the Excel App and the return. This is very inefficient

Most of the time the data to be processed should first be filtered so that it only shows the rows that need to be addressed. Then a single line of code can be used to update the filtered range block in one hit. In your example the code would be something like.

Please Login or Register  to view this content.

[daboho]

Please Login or Register  to view this content.