You need to give us a chronology of the errors, as you run the code in debug mode.
If the code is not protected, you will be given the Debug option upon errors.
After the first error message, click on Debug.
Now, where are you? You need to copy and paste the offending passage of code into your next post to this thread, letting us know what the first error message said, where you were tossed back into the code.
From that point, we can offer suggestions as to remedy, and you can try again, and perhaps get back to us where the second error (if any) occurs.
As to obvious problems, I was looking for Activate/Select methods, or perhaps trying to read a value of merged cells. 97 and XP have some differences on these two issues.