I'm getting a macro error in a file that hasn't been modified in nearly a year. I suspect it has something to do with the machine I'm using now which crashes Excel when I select yes to debug the code. So I am trying to manually step through the code using F8 to determine which line it doesn't like but I get to a certain point and then it tries to run the rest of the macro. Any reason why it would do something like this? In the meantime I'm going to put in a number of breakpoints to see if that helps me find the problem. Thanks