The reason you're getting such errors is that you have 'Option Explicit' set (good) but you haven't declared the variables before using them (bad) - which 'Option Explicit' requires. If you check the debugger, you'll see that 'LastValue' causes the error. Nowhere have you declared LastValue and neither have you given it a value. At a guess, I'd say it should be a worksheet reference. Similarly, the same line refers to a range named 'TotalEnrolledLast' but that range doesn't exist in the workbook - and neither does 'TotalCompleteLast'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Okay, that makes sense macropod. Now for the stupid question...

...how does one declare a value? Ex. "LastValue"

Someone helped me write this code, I am going to try and learn how to fix it.

Thank you MP

Assuming LastValue is a worksheet reference, you'd do that with code like:
Dim LastValue As Worksheet
then you need to tell VBA which worksheet LastValue refers to, using code like:
Set LastValue = Sheets("SomeWorksheetName")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]