Also, if you click on debug when you get the error, Excel should highlight the line of code where the error is occurring.