Loop in Range

[BJK1903]

Hello All,

I am trying to loop numbers in specific range. The code I have so far is not working 100%.

Please Login or Register  to view this content.

In some cases, when column number is less than loop number in range, the code does not work. For instance when cell value is "a" for I2, J4, and K5, looping numbers populated out of range. Is it possible to fix this issue. Thanks in advance.

[Norie]

What are you trying to do with the code/loop?

[Norie]

Oh, and why do you have so many loops?

[BJK1903]

I would combine these loops if I have little bit knowledge, I know it looks inefficient. I am trying to get this result

Please Login or Register  to view this content.

[Norie]

To loop through a range you should only really need one loop, probably the For Each from your code.

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[BJK1903]

Sure. Please see attached file

[Norie]

So you want to loop through H1:P10 an check the cells for 'a', then what...?

[BJK1903]

yes, vba code looks for "a" in the range and loop forward and backward right next to "a" cell. But there is a problem about looping it is looping out of the range, I want vba loop in the range H1:P10. with this code it is looping to F and G columns.

[Norie]

The For Each loop will loop through H1 to P10 but you never refer to the loop variable Cell anywhere else in the code.

These loops will go through A1 to O15.

Please Login or Register  to view this content.

[BJK1903]

yeap make sense that is why the code I put running out of range. So what should I put that works in the specific range.

[Norie]

If you want to loop through the range H1:P10 all you need us the For Each you already have in the code.

[protonLeah]

Please Login or Register  to view this content.

[BJK1903]

Great! it is working , thank you very much for your time.