for and next loop with if statment

Hello,

Here is my code:

Please Login or Register  to view this content.

Its pretty basic, but how do I adjust it to but the variable I, in after Z and the Row etc...


Thanks

Which column do you want to loop through? We know the rows are 20, but do not know which column.

Guess work

Please Login or Register  to view this content.

AB33 works great tthanks,

Mike,
You are welcome!