Unable to get cells to add and move macro correctly

[Hedron]

Hi,

I am trying to program a macro that will add up a set of cells in a column, limited to a date, then change the colour of a cell's background to reflect that person's "score" as a percentage.

This is what I have so far:

Please Login or Register  to view this content.

I have also attached the 2010 file. Attendance Tracker v1 public.xlsm

The goal is to press a button (not added in file) and have the macro run based on the date of the last lesson, and to colour the Present cell under each name yellow if the score is between 60 and 80%, and red if under 60%, and to do the same with the participated cell as well.

EDIT: The above code does partially the first thing (add), but I don't think the code is moving across columns correctly.

Please ask questions if you have them, I know my explanation is somewhat rambling.

Cheers,

Rob