Selecting range of cells for loop

[zoso88]

I've been tasked at work to write a macro to simplify calculating scores. I have wrote the for loop to calculate the score but I'm not sure how to select a cell to start at and then iterate through the rest of the cells in that row until a blank cell is reached then print the result in the cell below it.

For example the integer the score is calculated from is at B:2 and I need to print the score at C:2 etc.

Can provide a screenshot of what I mean if needed.

Any help will be very much appreciated!

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Mockup examples of the total you'd like to see...and where...point it out and we'll help automate that cell.