VBA Loop for Solver

Dear All,

I am not an expert of VBA at all, therefore, I'll try to be as clear as I can.

I am trying to create a code to automatically run a Solver across several columns. I managed to create a basic code that does the job, but that means that I have to copy and paste the code for all the rows I need it, and they are about 500.
I was wondering if you could kindly help me to make a code that loops through all the columns at regular intervals.

Here is a sample of what I need (without loop):

Please Login or Register  to view this content.

Could you be so kind to adjust it to make it loop until no columns are found?

Kind regards,

Simone

You could try something like this

Please Login or Register  to view this content.

This macro will loop from E column to G column to I column as I assume you run solver on every second column starting at the E column.

To find the last column with value perhaps check row 411 and replace 9 in macro above with:

Please Login or Register  to view this content.

Alf