I did solve my problem by deleting the worksheet that was causing the problems and creating a new worksheet with the same name. It ended up iterating correctly and haven't had a problem since. Sorry that it is probably not a solution that will solve your problem. It's weird that it does that