Did you get the error on the attached, or your actual sheet data?
Could it be my machine? its windows 7 with excel 2007
No, I do not think so. The error is on the code and we need to find it.