VBA loop down x number of cells, move to next column and loop again

[alex_santaana]

Good Morning Everyone!

I'm about 4 months into learning VBA so I'm still a beginner. I am trying to write a code and I'll do my best to explain what I'm trying to do. I have a worksheet with multiple columns of financial data going down the columns (In this case columns C,E,G,I,K....). Next to each column of financial data is a blank space where I will calculate the value to the left as a percentage of the overall values of that column. Once that is done, I want the loop to go two columns over and perform the actions again. This needs to be dynamic as reports have different number of rows and columns.

My logic is to create a loop within a loop that is able to start at the first occurrence of financial data in the first column, calculate each row of data until the final row at which point the inner loop would end triggering the outer loop to move to the next column and perform the inner loop again.

I am having a lot of trouble finding an answer for how to do this, specifically how to do a for loop within a for loop. I keep getting errors on my "Next" statement saying there is no "For". Any and all help will be greatly appreciated. Thanks everyone.

 

[igold]

Hi Alex,

Welcome to the MrExcel Forum.

Perhaps you could post your code so that we can see where you're at and why the code is throwing the error.

 

[SQUIDD]

hi

often, NEXT WITHOUT FOR is where you may have WITH without ENDWITH or IF without ENDIF.

But a suggested above, if you could share your code would help look into the problem.

Dave

 

[hiker95]

I'm about 4 months into learning VBA so I'm still a beginner.

alex_santaana,

Welcome to the MrExcel forum.


See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 03/20/2017


See reply #3, at the next link:

https://www.mrexcel.com/forum/excel-questions/999340-how-become-excel-master.html#post4796104

 

[hiker95]

alex_santaana,

Can we see what your current macro code looks like?


When posting VBA code, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]