Macro loop struggles

**Jstns** · 02-17-2017, 09:03 AM

Hi guys!

I would like to make a simple loop. I want the loop to add a X value (of 1) to multiple ranges in my code. VBA "Next without For". Could you tell me what I am doing wrong? Am it doing the

Please Login or Register  to view this content.

+x.value part right? I want the code to add x (1) to the range everytime it loops.

Thank you very much in advance!

Please Login or Register  to view this content.

**davesexcel** · 02-17-2017, 09:12 AM

Start the loop where you want it to start, not at the beginning of the code. Possibly after you set the workbooks.

You probably don't need x.value, just x