Hi, I'm very new to VBA but havea solver function that I need to apply to
each row in my spreadsheet. A macro is the best way to do this as there are
100 rows.

I have recorded a macro that does what I want for a single row, but when I
try and create a loop things go wrong. I can't figure out how to refer to the
cells that Solver uses so that they use the right ones for each iteration.
I've tried both the A1 style and the R1C1 style.

I did find some help on the website (but cannot find the page today) that
used a FOR loop with the "Counter" command, but this doesn't seem to work.

In each iteration the columns stay the same, its just that obviously the
rows need to change each time.

Does anyone have any advice? I can post the code I have at present if needed.

Many thanks for any help.