Okay. That's great. Everything is working now and I only have one more problem. I know I've see nsolutions to similar problems, but I'm not sure they pertain to this specfic situation. When I move to the report sheet, the macro runs and end up back on the Data sheet. Is there something I can do to remain on the Report sheet?