I am unable to debug for you. The only thing I noted is that startdate and finishdate are not assigned values, so the initial run through errored on those lines that set the range. Once I assigned suitable values to those variables (I used 2 and 20, since those are the rows I used for the dummy data I tested on), the code seemed to run just fine. I guess I can suggest that you check the values for startdate and finishdate (using locals window or other debug tool: http://www.cpearson.com/excel/DebuggingVBA.aspx ) and make sure they are reasonable. Other than that, I see nothing wrong with the code you posted.